On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > 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.
I suppose if the seq value has some real meaning, yo umight need to fuss around with a way to ensure things are 'in sequence' so to speak. Typically I could care less, the sequence is usually a PK and has no real meaning to the end user/gui. IIRC, there is no guarantee a numerical sequence in Oracle is always one apart. You could get 1,2,3,4,10,11,20. That is what I've been told at least. 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. If your SQL has only one insert, why use a transaction? Vacuously its considered a transaction I suppose. Further, if a single SQL fails in CF, a commit is never issued for it. I have always understood transactions to be a group of SQL statements that you want to execute in concert. On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > > > > > > note a rollback does not effect sequences. > > > > DK > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211594 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
