> 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
