Paul, my understanding is CFTransaction is used to group one block of code
together. e.g. the typical use is:
1. insert row to table
2. find out maximum ID in that table (i.e. ID of the row just inserted)
3. update table with ID = the maximum you just found out.
Obviously this would all be grouped as one transaction, lest someone add a
new row to the table in between steps 1 and 2 above. If you're just
displaying some select boxes, I'm not sure why you'd need to use it?
"Paul Swingewood"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
tmail.com> cc:
Subject: [ cf-dev ] <cftransaction>
03/08/2004 10:21
Please respond to
dev
I have 5 queries which populate drop down lists.
I have just been reading up on <cftransaction>. Should I put all of these
queries inside a <cftransaction> tag? - Does this increase speed? - How &
why?
I don't think I need all this rollback stuff as I am only reading to
populate dropdown lists.
Regards - Paul
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
