I had to go and make that very same change a couple years ago, so I can totally understand missing that. Glad to be of help.
Cheers, Judah On Tue, Sep 29, 2009 at 1:29 PM, Robert Harrison <[email protected]> wrote: > > Man. Now I'm glad I posted that. > > Just went through and changed all: > > SELECT @@Identity AS newId > > To > > SELECT SCOPE_IDENTITY() AS newId > > Looks like it worked. I've been using that statement for six or seven years. > Never failed, but I could see where if it did I'd have had no idea what > happened. > > Thanks for clearing that up. > > > Robert B. Harrison > Director of Interactive Services > Austin & Williams > 125 Kennedy Drive, Suite 100 > Hauppauge NY 11788 > P : 631.231.6600 Ext. 119 > F : 631.434.7022 > http://www.austin-williams.com > > Great advertising can't be either/or. It must be &. > > Plug in to our blog: A&W Unplugged > http://www.austin-williams.com/unplugged > > > > > __________ Information from ESET Smart Security, version of virus signature > database 4468 (20090929) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326762 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
