Yes, but isn't the point in doing the CFTRANSACTION in the way I am describing to ensure that you get the ID of what you just inserted in order to pass it back to the website? More than likely to pass it back with a URL for telling the user hey this is where you go to view status or to edit what you just put in our database. I thought the point in doing the CFTRANSACTION for this was not so that you can do a rollback on the sequence(which we all agree can not happen anyway) but was to ensure when things are being inserted by multiple people and around the same times that each person gets the ID that belongs to them.
On 7/12/05, Douglas Knudsen ok. as I mentioned earlier in the this thread, a rollback does not effect a sequence. So wrapping a transaction around these too queries is no different really then wrapping it around the single insert. 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:211630 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
