How many times would it really matter if it did? I have seen sometimes where a "new app" would start off at say ID value of 143 just because of all the testing and not resetting the sequence never seemed to be an issue though. Guess I just look at it differently, because the way I look at it is if the CFTRANSACTION is not going to hurt anything to be used then why the heck not use it around even something so simple as the basic insert vs lots of inserts/updates. Seems like the only difference is one way saves you from typing the opening/closing transaction tags. But if less typing were the goal then I'd say the SP would lead to the least amount of typing, at least within the CFM files.
On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > > > note a rollback does not effect sequences. > > 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:211584 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54