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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple Statements in a cfquery with mySQL
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=subscribeforumid=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