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

Reply via email to