I followed your instructions but I get this error when I press submit on the
webpage.
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','', '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'.
Can you help ?
>Don Barron wrote:
>>
>> I dont know much about ASP, would someone be prepared to make these
changes?
>
>You can choose the second option:
>
>1. Run Enterprise manager, connect to your server.
>
>2. Bring up the Query Tool, and execute the query:
> Select * From BillingCycles
>
>3. Find the BillingCycleID of the one you want to be the default.
>
>4. In the server manager window, drill down to Databases, Emerald,
> Objects, tables, MasterAccounts and select edit.
>
>5. Find the BillingCycleID Row (probably near the bottom), and in the
>default column (the one on the right) enter the number you found in step
>#3.
>
>6. Save the changes and exit.
>
>> >
>> >> The ones written in ASP on the IEA ftp server were done by me.
>> >> However people have reported that the scripts don't work
>> >> with the updated 2.5 database. I am re-working these pages
>> >> for use with IE 5.0 and Emerald 2.5, I should have a new version
>> >> shortly.
>> >>
>> >> P.S. If you know ASP then I have been told that the fixes are
>> >> pretty easy to go about fixing...but again I haven't looked too deeply
>> into
>> >> them yet.
>> >
>> >The big gotcha between 2.2 signup and 2.5 signup is that you
>> >MUST either:
>> >
>> >1) Include a BillingCycleID by the signup server
>> >
>> >2) Put a default on the BillingCycleID column in the masteraccounts
>> > table that is from the BillingCycles table.
>> >
>> >If the BillingCycleID field in the MasterAccounts table does NOT
>> >match an enrty from the BillingCycles table, Emerald 2.5 can not
>> >bill the user.
>> >
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com