I think that's the case, which is a bummer because I have thousands of statements which are logically grouped in <cfquery></cfquery> tags
I'm using the Oracle driver that comes with CF 8. Thanks Victor On Sat, Oct 31, 2009 at 1:05 PM, Dave Watts <dwa...@figleaf.com> wrote: > >> It doesn't work either. >> >> I need to run multiple sql statements in one <cfquery></cfquery> tag. >> >> It appears an Oracle limitation. > > Many JDBC drivers turn this functionality off by default, to prevent > potential security problems I suppose. You may have to look into your > JDBC driver settings. Or, run them as separate queries within the same > page, which will have the same effect. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4