not if you use stored procs, or a package (bunch of procs and functions) you just leave the "rollback; /" and "commit; /" statements out and use cftransaction to execute them.
Steven D. Dworman Certified Macromedia Developer -------------------------------------------- Web Consultant Systems Administrator phone: 248.647.8841 cell : 248.767.9925 -------------------------------------------- Comspec International Empower-XL Software for Higher Education http://www.ComspecInternational.com ----- Original Message ----- From: "Deanna Schneider" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 8:46 AM Subject: Re: getting auto id > Hmmmm, my understanding is that their is an implicit "commit" with each hit > to Oracle from the CF-User, which nullifies any benefits of cftransaction, > and makes it not a guarantee that the currval will work. I'd be psyched if I > was proven wrong. But, that's the info that I have from my DBA and others. > > -Deanna > > > Deanna Schneider > Interactive Media Developer > [EMAIL PROTECTED] > > > ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
