For stored procedure Railo has <cfstoredproc*> Just like Adobe CFMX
from online help <!--- This view-only example executes a Sybase stored procedure that returns three result sets, two of which we want. The stored procedure returns the status code and one output parameter, which we display. We use named notation for the parameters. ---> <!--- <cfstoredproc procedure = "foo_proc" dataSource = "MY_SYBASE_TEST" username = "sa" password = "" dbServer = "scup" dbName = "pubs2" returnCode = "Yes" debug = "Yes"> <cfprocresult name = RS1> <cfprocresult name = RS3 resultSet = 3> <cfprocparam type = "IN" CFSQLType = CF_SQL_INTEGER value = "1" dbVarName = @param1> <cfprocparam type = "OUT" CFSQLType = CF_SQL_DATE variable = FOO dbVarName = @param2> </cfstoredproc> On 2/8/07, Peter Boughton <[EMAIL PROTECTED]> wrote: > > >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:269085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
