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=3Dtrue

Is there something similar in MyODBC?

Thanks,
-Ryan


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg

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 [at] nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org