Hmmmm.....I don't know. I haven't used Oracle since my college days, and we certainly never got that far.
Maybe this thread will send you down the right road? Although, I *think* if you just use the Max(ID) whilst using cftransaction, you'll gain the same results. Torrent Girl wrote: > Is @@IDENTITY availabe in Oracle? > > > > >> Or use cftransaction - do the DB insert, then get the @@IDENTITY - the >> ID of the inserted record on the second page - in one database >> transaction. Then you'll have it on that page, pass it as a hidden form >> field to the last page, and do an update using that ID. >> >> That's one way to do it.... >> >> Torrent Girl wrote: > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1651 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
