[Emerald] Online signup

Don Barron ( (no email) )
Wed, 14 Apr 1999 15:08:46 +0930

Howdy List,

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
LastModifyDate,LastModifyUser,maCurrent,maNew,GroupID) VALUES
('Don','Barron','','8 Quinvale Rd','', 'Adelaide','SA','5000','08 8123
4567','08 8123 4567','08 8123
'Monthly','Invoice',DEFAULT,'', '','','', 'On-Line SignUp from
[]', 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...
>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%