This message is usually caused by a permissions problem with the
database. Is it set to read-only?
Also suggest making that thread_time field an ODBC date/time.
Nick
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 12:36 PM
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
