This is from the signup perl file on the emerald ftp site. Can anyone shead
some light on why I get this error after pressing submit.
------
INSERT INTO MasterAccounts
(FirstName,LastName,Company,Address1,Address2,City,State,Zip,PhoneHome,Phone
Work,PhoneFax,
Region,CreateDate,StartDate,maExpireDate,Extension,Active,PayPeriod,PayMetho
d,LastReceived,
PONumber,CreditCardNumber,CreditCardExpire,CreditCardAuth,Comments,
LastModifyDate,LastModifyUser,maCurrent,maNew,GroupID) VALUES
('Don','Barron','','8 Quinvale Rd','', 'Adelaide','SA','5000','08 8123
4567','08 8123 4567','08 8123
567','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'.
------
Any help would be good.
~~~~~~~~~~~~~~~~~~~~~~~~~~
Don Barron
World-Link Internet
Email: don@world-link.com.au
Web: http://www.world-link.com.au
Thought of the Day:
NEWS! Iraqi head seeks arms
~~~~~~~~~~~~~~~~~~~~~~~~~~
-----Original Message-----
From: Ronnie D. Franklin <ronnie@itexas.net>
To: Emerald Mailing List <emerald@iea-software.com>
Date: Wednesday, 14 April 1999 2:47
Subject: [Emerald] FYI - CALLSONLINE
>For the past few months I have noticed that my callsonline has not always
>been current... missing users that were logged in, and keeping users in the
>view that were gone.. also some of the users that had gone away were still
>in the callsonline, but the IP address had disappeared...
>
>FWIW....
>
>I did some cleanup on my calls database... 950,000 records... deleted
>460,000 records... every since then, the callsonline view has been 99.9%
>accurate...
>
>
>