Bryan, Thanks for your response.
Would this prevent other queries from running on my ColdFusion Server at the same time? How does <cftransaction> control this? Is it better to use <cftransaction> over a stored procedure? Thanks, Troy Bryan Love wrote: > CFTRANSACTION > > do this: > > <cftransaction> > INSERT query > > SELECT sequence.currVal query > </cftransaction> > > The transaction tags force both queries to run as a single transaction which > means it's not possible for any other inserts to happen between them - or > even at the same time. > > + > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists