what is a cascading delete? ----- Original Message ----- From: "Aidan Whitehall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 17, 2001 12:45 PM Subject: RE: CFQUERY
> > Is there a way to do multiple delete queries in one cfquey tag. and I > > need to surround it in a transaction. How can I do this? > > No, but if you supply a where clause, you can delete everything from one > table in one go (and if you have cascading deletes, just go for the > parent-most records). > > > <CFTRANSACTION> > <CFQUERY...> > DELETE > FROM x > WHERE ... > </CFQUERY> > > <CFQUERY...> > DELETE > FROM y > WHERE ... > </CFQUERY> > </CFTRANSACTION> > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Macromedia ColdFusion Developer > Fairbanks Environmental +44 (0)1695 51775 > > _____________________________________________________________________ > This message has been checked for all known viruses by Star Internet > delivered through the MessageLabs Virus Scanning Service. For further > information visit http://www.star.net.uk/stats.asp or alternatively call > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists