Re: [Emerald] ONLine Setup

Don Barron ( (no email) )
Thu, 15 Apr 1999 13:35:00 +0930

Yeah I got that part but I dunno where it is getting it from.

The page is here if anyone wants to look
http://www.world-link.com.au/signup/signup.pl

>It looks like the error is wherever the date is generated... as it is
trying
>to put a 0.00 in the dateadd function.....
>
>> INSERT INTO MasterAccounts
>> (FirstName,LastName,Company,Address1,Address2,City,State,Zip,Phone
>Home,Phone
>> Work,PhoneFax,
>> Region,CreateDate,StartDate,maExpireDate,Extension,Active,PayPerio
>> d,PayMetho
>> d,LastReceived,
>> PONumber,CreditCardNumber,CreditCardExpire,CreditCardAuth,Comments,
>> LastModifyDate,LastModifyUser,maCurrent,maNew,GroupID) VALUES
>> ('Don','Barron','','8 Quinvale Rd','', 'Hallett Cove','SA','5000','08
8387
>> 3062','08 8231 0999','08 8212 8805',
>> 'Adelaide',DEFAULT,DEFAULT,
>
>
>
>dateadd(dd,0.00,getdate()),
>
>
>
>
>DEFAULT,DEFAULT,
>> 'Monthly','Invoice',DEFAULT,'', '','','', 'On-Line SignUp from
>> [203.25.61.21]', DEFAULT,'signupsrv',DEFAULT,DEFAULT,4.00)
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 10: Incorrect syntax
>> near '0.00'.