Can we loop all the recordsets in the stored procedures with CF 4.5 and
Oracle 8.1?
I have done this with ASP and SQL Server 7.0:
E.g.
create procedure sp_Money
select * from tbl1 where fname = "mei";
select * from tbl2 where targetSalary = "1,000,000";
then, after execute the stored procedure, we can loop it as:
objRec = NextRecordset; ( not exactly syntax, but the idea is there...)
do while not objRec.eof
--- objRec will be all the records return from the first select...;
objRec = NextRecordset;
--- this time, objRec will be all the records from the second select...
CAN we do that? Any information is greatly appreciated.
Mei
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists