If you want to run multiple statements in a single cfquery tag in oracle you need to write PL/SQL. An anonymous block would do the trick.
mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/31 Victor Moore <victor.mo...@gmail.com>: > > Hi, > > I'm trying to migrate a MS-SQL db to oracle and when trying to load > the database I get the following error: > [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not > properly ended > > the script I'm running is: > <cfquery name="q" datasource="db_ora"> > insert into user_access values (3, 'Admin') > / > insert into user_access values (4, Partner') > / > insert into user_access values (5, 'Client') > / > </cfquery> > > I have tried with ; and without any statement terminator. > > It works fine with only one statement in the cfquery and it works fine > when running against a SQL db. > Is it possible to run multiple sql statements inside a cfquery agai ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
