I see an extra apostrophe in your debug SQL. If this is a typo, fine, but
if you cut and pasted this in, there's your bug.
I used to work with CF and Paradox when I lived in Chicago. Feel free to
contact me directly if you have any more questions about this mix.
cg
Christian Gustafson
Senior Software Engineer
Onvia.com
Work. Wisely.
http://www.onvia.com
(p) 206.373.9307
(c) 206.852.6095
-----Original Message-----
From: Jessica Ogle [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 2:52 PM
To: CF-Server
Subject: problems inserting into Paradox table
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
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
