With SQL server that's true yes, no issues there. But not with mySQL or so it seems, the ODBC drivers chokes the instant you start a 2nd statement no matter what it is (or so it seems). Just wondering why really and if it's ever likely to change with future realeases of mySQL ODBC or CF.
-----Original Message----- From: Ken Wilson [mailto:[EMAIL PROTECTED] Sent: 24 June 2003 11:49 To: CF-Talk Subject: RE: Multiple Statements in a cfquery with mySQL I do believe it depends on what you are doing in the SQL statements. As long as you are only bringing back one recordset it should not be a problem. -----Original Message----- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 6:37 AM To: CF-Talk Subject: Multiple Statements in a cfquery with mySQL Just a quickie, Running multiple statements at once works fine in mySQL, but not from a cfquery (cf5), I assume it's an ODBC driver issue, or is it cf? Anyone know for sure? Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> MS Messanger: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> www: www.netstep.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4