Thanks for the advice all. I learned a few things today..... Robertson-Ravo, Neil (RX) wrote: > IDENTITY can also lead to strange results. May be better to use > SCOPE_INDENTITY or IDENT_CURRENT. > > > (on SQL Server) > > > > -----Original Message----- > From: Calvin Ward [mailto:[EMAIL PROTECTED] > Sent: 11 May 2005 12:36 > To: CF-Talk > Subject: RE: getting the record I just inserted > > I like this plan. > > -----Original Message----- > From: Matt Robertson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 10, 2005 6:34 PM > To: CF-Talk > Subject: Re: getting the record I just inserted > > I do something similar to what Lorne does, although I use a UUID so > that there is NO chance of collision (if you use time like that you > aren't truly safe). There is no need to mess around with cflocks, > cftransactions etc. with this method, and it works unmodified on all > db platforms (SELECT @@IDENTITY is only good for SQL Server and maybe > Access... other platforms require different platform-specific methods > to do the job). > > I like the UUID so I can write one solution and apply it to all > platforms (something not everyone needs to do, admittedly) and I > usually find a use for a UUID one way or another within a db record, > so its not really an 'extra' field in my table.. > >
-- ================================================================= Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org ================================================================= The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:206337 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
