Using a cftransaction for a single statement is not necessary. If the
update or insert statement fails.... It fails. There are no dependant
queries that rely on that information being correct. I use cftransaction
for multiple inserts or related updates, etc... (although I typically use
stored procs for this) and for the single ones that I want to gracefully
catch, I use cftry/catch blocks.
Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: John Barleycorn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 9:51 AM
To: CF-Talk
Subject: cftransaction
Hello, is there ever a reason to use cftransaction around a single query? I
currently use it around queries that are dependant on each other, but
another coder is using cftransaction around single queries. Just wondering
if this is correct or just a waste. thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
