i see no reason to use it in Daniels case. once you get the next value from a sequence in Oracle, no other request will get that id.
Now, if Daniel needed to perform several inserts, updates, etc in one request based on this id, then yes, by all means use cftransaction. In his case he had only one. note a rollback does not effect sequences. DK On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > Is there a reason to want to avoid using cftransaction? > > On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > > > > and you do not need cftansaction either. once query 1 executes, you have > > the > > id in hand. if another request came in it would get a differnt id. > simply > > based on the uniqueness of the sequence. > > > > DK > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211581 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
