22. februar 2002 - 17:20
Der er
5 kommentarer og 1 løsning
SQL Syntaks fejl
Hvad er fejlen i følgende gemte procedure: CREATE PROCEDURE dbo.up_parmupd_UserT_CCT (@Firstname VarChar(50), @Lastname VarChar(50), @EmailAddress VarChar(50), @Username VarChar(30), @Password VarChar(10), @CCType VarChar(20), @ExpMonth Int, @ExpYear Int, @CCNumber Uniqueidentifier, @Donations Money) AS UPDATE User_T JOIN Creditcard_T ON Creditcard_T.Creditcard_ID = User_T.Creditcard_ID SET First_Name_VC = @Firstname, Last_Name_VC = @Lastname, Email_Address_VC = @EmailAddress, User_Name_VC = @Username, Password_VC = @Password, Creditcard_Type_VC = @CCType, Creditcard_Exp_Month_IN = ExpMonth, Creditcard_Exp_Year_IN = @ExpYear, Creditcard_Number_UI = @CCNumber, Donations_MN = @Donations WHERE User_Name_VC = @Username AND Password_VC = @Password Jeg får fejlmeddelelsen: Server: Msg 156, Level 15, State 1, Procedure up_parmupd_UserT_CCT, Line 13 Incorrect syntax near the keyword 'JOIN'.
Annonceindlæg fra itavis
22. februar 2002 - 17:35
#1
Prøv dette: CREATE PROCEDURE dbo.up_parmupd_UserT_CCT (@Firstname VarChar(50), @Lastname VarChar(50), @EmailAddress VarChar(50), @Username VarChar(30), @Password VarChar(10), @CCType VarChar(20), @ExpMonth Int, @ExpYear Int, @CCNumber Uniqueidentifier, @Donations Money) AS sql = Conn.Execute("UPDATE User_T JOIN Creditcard_T ON Creditcard_T.Creditcard_ID = User_T.Creditcard_ID SET First_Name_VC = @Firstname, Last_Name_VC = @Lastname, Email_Address_VC = @EmailAddress, User_Name_VC = @Username, Password_VC = @Password, Creditcard_Type_VC = @CCType, Creditcard_Exp_Month_IN = ExpMonth, Creditcard_Exp_Year_IN = @ExpYear, Creditcard_Number_UI = @CCNumber, Donations_MN = @Donations WHERE User_Name_VC = @Username AND Password_VC = @Password")
22. februar 2002 - 17:39
#2
Duer ikke!
22. februar 2002 - 18:11
#3
hmm... Hvad er det her: CREATE PROCEDURE dbo.up_parmupd_UserT_CCT (@Firstname VarChar(50), @Lastname VarChar(50), @EmailAddress VarChar(50), @Username VarChar(30), @Password VarChar(10), @CCType VarChar(20), @ExpMonth Int, @ExpYear Int, @CCNumber Uniqueidentifier, @Donations Money) AS
22. februar 2002 - 20:01
#4
Jeg syntes der mangler noget!!!
25. februar 2002 - 11:14
#5
Hvad skal Conn.Execute inde i dit SQL statement ? Jeg har ikke nærlæst din SP, men fjern "sql = Conn.Execute"
05. marts 2002 - 17:26
#6
Point retur
Kurser inden for grundlæggende programmering