Do You realy need the ; at the end of the Query?
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 11:36
To: CF-Talk
Subject: query error
Hello,
Must be having a brain spasm today....I am getting this error message:
Message: ODBC Error Code = S1000 (General error)
Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access
Driver] Operation must use an updateable query.
SQL = "INSERT INTO tbl_threads (operaID, thread_title, thread_body,
thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01);"
This is the query that seems to be causing the problem:
<cfquery name="addthread" datasource="#APPLICATION.chatdsn#">
INSERT INTO tbl_threads (operaID,
thread_title,
thread_body,
thread_author,
thread_time)
VALUES (#url.operaID#,
'#Form.thread_title#',
'#Form.thread_body#',
#checkauthor.authorID#,
#dadate#);
</cfquery>
Any ideas anyone?
TIA
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists