Andy,
I think you can still execute procs in <CFQUERY>. If you want, try using CF
to build up the SQL that calls the proc in variables, and then send it to
the server by putting the #sqlprocstmt# inside a <CFQUERY> block. e.g.:
<CFQUERY ... >#sqlprocstmt#</CFQUERY>
Executing procs via <CFQUERY> limits you to capturing only 1 result set (for
more than 1 result set you need <CFPROCRESULT>).
Please do post back and let us know what approach you end up using.
Also, just curious, what database are you using?
hth,
g
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263884
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
