Paul can I ask why you need to use cftransaction. What is the desired functionality ?
I can't see how it would increase speed. If you're on SQL Server you could use a stored procedure with transactional logic with multiple result sets but again depends what youre trying to do ? Alex -----Original Message----- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 03 August 2004 10:22 To: [EMAIL PROTECTED] Subject: [ cf-dev ] <cftransaction> 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.657 / Virus Database: 422 - Release Date: 13/04/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.657 / Virus Database: 422 - Release Date: 13/04/2004 -- 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]
