>In 1.0 it is possible to call stored procedures in <cfquery>. Railo 1.1 >will support <cfstoredproc*>
I thought that was the case, but I did a quick test with MySQL 5 and it didn't appear to work. The procedure was just a sample one I found: CREATE PROCEDURE molo() SELECT 'Molo'; And when trying to do this: <cfquery name="Bob" datasource="Test"> CALL molo() </cfquery> I got this: null, message from server: "PROCEDURE test.molo can't return a result set in the given context" Did I do something wrong? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http: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:269084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
