I am trying to write a ColdFusion application using Paradox tables. I can read the
tables just fine, but when I try to insert new records I am having major problems. If
the table is empty, the record goes in just fine, but if there are any records in the
table my query fails with the following message:
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Paradox Driver] Operation must use an updateable query.
SQL = "Insert into logon_log (Account_ID, User_Name) values ('12345'','John Smith')"
Data Source = "j_steers"
The error occurred while processing an element with a general identifier of (CFQUERY),
occupying document position (9:1) to (9:48) in the template file
C:\Inetpub\wwwroot\web_steers\testquery.cfm.
Date/Time: 11/08/00 16:50:23
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95)
Remote Address: 127.0.0.1
Does anyone know what I need to do to be able to insert? I haven't even tried to
update yet....
Thanks,
Jessica Ogle
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
