On my clothing database, I have a situation where I have to delete from one FK table, then the PK table. I do it in one cfquery like so:
<cfquery datasource="#DSN#"> DELETE FROM dbo.tblavailablecolors WHERE prodID='#URL.ID#'; DELETE FROM dbo.tblproducts WHERE prodID='#URL.ID#' </cfquery> 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? Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190381 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
