There are four fields that come from the Creditcard_T Table, which is:

Creditcard_Type_VC, Creditcard_Exp_Month_IN,

Creditcard_Exp_Year_IN, Creditcard_Number_UI



Regards Christian Dygaard





-----Oprindelig meddelelse-----

Fra: Breidenbach, Beth [mailto:Beth.Breidenbach@g...]

Sendt: 22. februar 2002 21:23

Til: ASP Databases

Emne: [asp_databases] RE: SQL Syntax Error





What's the purpose of the join to CreditCard_T?  Which fields come from it?



-----Original Message-----

From: Christian Dygaard [mailto:cdygaard@w...]

Sent: Friday, February 22, 2002 12:06 PM

To: ASP Databases

Subject: [asp_databases] SQL Syntax Error





Hello fellow programmers



I get an error parsing this stored procedure:



CREATE PROCEDURE dbo.up_parmins_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

INSERT INTO User_T (First_Name_VC, Last_Name_VC,

Email_Address_VC, User_Name_VC, Password_VC,

Creditcard_Type_VC, Creditcard_Exp_Month_IN,

Creditcard_Exp_Year_IN, Creditcard_Number_UI,

Donations_MN) VALUES (@Firstname, @Lastname,

@EmailAddress, @Username, @Password, @CCType,

@ExpMonth, @ExpYear, @CCNumber, @Donations)

JOIN Creditcard_T ON

Creditcard_T.Creditcard_ID = User_T.Creditcard_ID

WHERE User_Name_VC = @Username AND

Password_VC = @Password



I get the error message:



Server: Msg 156, Level 15, State 1, Procedure up_parmins_UserT_CCT, Line 19

Incorrect syntax near the keyword 'JOIN'.



What's the problem?



Thanks in advance



Regards Christian Dygaard






$subst('Email.Unsub').






$subst('Email.Unsub').