in oracle i use it with procedures. since i've found that it's not proper to
put commits and/or rollbacks inside the procs cftransaction comes in handy.
you can control a commit or a rollback per transaction to the db. it also
allows you to use isolation (locking in the db), but i haven't used that at
all since oracle does a good job of that.
John Barleycorn <[EMAIL PROTECTED]> said:
> 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
