Re: Muliple query execution

[Daniel Kasak]

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: ([phone] / F: ([phone]
email: dkasak@stripped
website: http://www.nusconsulting.com.au