It appears the second insert statement in your cfquery is missing a
single-quote (') around Partner. That might be causing a problem.
Seth
On Sat, Oct 31, 2009 at 11:16 AM, Victor Moore <victor.mo...@gmail.com>wrote:
>
> It doesn't work either.
>
> I need to run multiple sql statements in one <cfquery></cfquery> tag.
>
> It appears an Oracle limitation.
>
> Thanks
>
> On Sat, Oct 31, 2009 at 11:38 AM, James Holmes <james.hol...@gmail.com>
> wrote:
> >
> > Wrapping BEGIN and END around the statements should be enough.
> >
> > http://docstore.mik.ua/orelly/oracle/prog2/ch15_03.htm
> >
> > http://www.orafaq.com/wiki/Anonymous_block
> >
> > etc
> >
> >
> > mxAjax / CFAjax docs and other useful articles:
> > http://www.bifrost.com.au/blog/
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:327863
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
