Will Tomlinson wrote: > <cfquery datasource="#DSN#"> > DELETE FROM dbo.tblavailablecolors WHERE prodID='#URL.ID#'; > DELETE FROM dbo.tblproducts WHERE prodID='#URL.ID#' > </cfquery>
i'd wrap a SET NOCOUNT ON/OFF around these (assuming it's sql server) to shave some time/traffic off these. > I started thinking about my product insertion scenario. It runs though 4 > inserts with multiple cfquerys on one page. Why couldn't I place all of them > into one cfquery? Wouldn't it execute faster? Or is this a tacky way to do > things? sure. why not? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190382 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
