Thank you all for the great inputs. On Tue, Sep 29, 2009 at 1:48 PM, Judah McAuley <[email protected]> wrote:
> > 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:326764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
