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:326760
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
