Bryan said: >Different DB's provide different ways of doing this, but the only universal >way I know of is this: <cftransaction> .. </cftransaction>
Actually, there's some contention about this method with Oracle. Some poeple say there's an implicit commit with every call from CF to Oracle, thereby blowing away your transaction after the first cfquery. Other people disagree with that, but in the "better safe than sorry" approach, if you're using Oracle, you should consider selecting the next value from a sequence FIRST, and then use the value to populate your primary key second. -d 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists