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.
Jim >> Anyone know if there is an advantage either way when it comes >> to calling a stored procedure? > >In the example you provided, there's no difference, but stored procedures >can be much more complex than a single SQL statement. Stored procedures can >return multiple recordsets, they can accept and return parameters. The >CFSTOREDPROC tag allows for all that. Also, you can't use CFQUERY on all >platforms to execute stored procedures, as I recall. But if you don't have >any of these issues there's nothing wrong with using CFQUERY instead, and >there are some advantages, such as the ability to use >CACHEDWITHIN/CACHEDAFTER. > >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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270618 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
