Re: [Emerald] ONLine Setup

Don Barron ( (no email) )
Thu, 15 Apr 1999 16:29:27 +0930

>>
>> [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement
conflicted with COLUMN FOREIGN KEY constraint
'FK__MasterAcc__PayMe__7829DFE5'. The conflict occurred in database
'Emerald', table 'PayMethods', column 'PayMethod'
>>
>> /signup/signup.asp, line 1877
>>
>> I am new to ASP but I learn fast. Could anyone help me?? Please?? =)
>
>
>I'm not familiar with the ASP script (I just downloaded it myself and
>will take a look as I get time), but I do know what the SQL Error is.
>This is a result of the Pay Method (in your case Visa) not matching one
>of the PayMethods from the PayMethods table. It should be "Credit
>Card",
>not Visa. We consolidated all the CC paymethods into one for Emerald
>2.5.
>

Ahh cool, I got the same error when trying that signup server. Do you think
you'd be able to supply a fix for it Dale ?

Cheers