> Thanks for your input, Dave. My concern is the processing > overhead that is incurred by using CFSTOREDPROC. Do you know > of any way to access multiple recordsets in CFQUERY? As it > stands now, CFQUERY only returns the 1st recordset while > ignoring the rest. The ability to pull multiple recordsets, > in my opinion, is the only advantage to CFSTOREDPROC.
I don't know that there's any significant processing overhead specific to CFSTOREDPROC. I don't know of a way to return multiple recordsets with CFQUERY, and I don't think it's possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270623 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
