have you got a CFTRANSACTION around it at all? Steve
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Darren Tracey Sent: Wednesday, March 10, 2004 5:05 PM To: CFAussie Mailing List Subject: [cfaussie] JDBC SQL problems I'm converting all my SQL to use a JDBC datasource instead of the original ODBC datasources, to avoid the mysterious server crashes as detailed in other threads. With the modifications I explained in my original emails, all my SELECT statements work fine. Every single insert, update and delete statement causes this error: ------------------------------------------------------ Error Executing Database Query. Method can be called only once. The error occurred in D:\Inetpub\wwwroot\Development\APPName\dirname\templateName.cfm: line 55 53 : DELETE FROM table1 54 : WHERE field1='#VARIABLES.field1val#' 55 : AND field2='#VARIABLES.field2val#' 56 : </CFQUERY> 57 : <CFELSE> SQL DELETE FROM table1 WHERE field1='xx' AND field2='yy' DATASOURCE DARREN VENDORERRORCODE -79782 SQLSTATE IX000 Please try the following: ------------------------------------------------------ This page: http://www-306.ibm.com/software/data/informix/pubs/library/notes/relnotes/JD BCdr20.html tells me this about this error code: -79782 Method can be called only once Make sure methods like Statement.getUpdateCount() and Statement.getResultSet() are called only once per result. I am not doing either of these things, and if CF is, then there's not much I can do about it (is there?). Help!!!! Any ideas? Regards Darren Tracey JDBC victim --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
