Is your OperaID an autonumber field perchance? Trying to insert a value into
an autonumber field is not going to happen.
Steve
> -----Original Message-----
> From: Will Swain [mailto:[EMAIL PROTECTED]]
> Sent: 14 May 2001 12: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
