From: Date: September 9 2005 2:37am
Subject: Re: Muliple query execution
List-Archive: http://lists.mysql.com/myodbc/10332
Message-Id: <4320D962.3030001@nusconsulting.com.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Ryan Stille wrote:

>I'd like to be able to run more than one query inside one single
><CFQUERY> block in my ColdFusion 5 application.  I am doing this now
>with SQL Server, but we are migrating to MySQL.
>
>I've found that there is a way to do multiple queries in JDBC using the
>allowMultiQueries paramter in the JDBC connection URL like this:
>jdbc:mysql://192.168.1.36:3306/mydb?allowMultiQueries=true
>
>Is there something similar in MyODBC?
>  
>
Not in the current version. I think version 5 will support this, but 
there's only been an initial release of this so far, and I haven't tried 
it yet because it doesn't work with Access. You can try it out though :)

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@stripped
website: http://www.nusconsulting.com.au