> 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270489 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
