thats my thinking as well will so if i have 1 product in 1 table then i dont have to do a looping delete as well but what do i know?
---------- Original Message ---------------------------------- From: Will Tomlinson <[EMAIL PROTECTED]> Reply-To: cf-talk@houseoffusion.com Date: Thu, 13 Jan 2005 23:31:37 -0400 >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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Flash for programmers - Flash MX Pro http://www.houseoffusion.com/banners/view.cfm?bannerid=56 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190385 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54