I have always have been under the impression that all I had to do was:
<CFTRANSACTION>
Query 1
Query 2
Query 3
</CFTRANSACTION>
With each query wrapped it's own CFQUERY tag.
However, I have never had the oportunity to test it.
Russel
============================================================
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Some days you eat the bear; some days the bear eats you.
============================================================
> -----Original Message-----
> From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 13:08
> To: CF-Talk
> Subject: CFTRANSACTION - proper usage
>
>
> I have three queries that insert information, I need to be sure
> that all three inserts take place, if not they are discarded.
> How would I use cftransaction to accomplish this task?
>
> Thanks,
> Dave
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists