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:1649 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
