Ok, I found this: http://www.sqlteam.com/item.asp?ItemID=319
I've been using code that originally ran on Access. Looks like it's time to do some searching and replacing. Thanks all, Mik >Incidentally, you should look at using scope_identity() instead of >@@identity. @@identity does not always return the ID of the record you >just added, particularly if there is a trigger on that table. It could >return the ID of a record that was added by the trigger instead of your >actual insert statement. In most cases you would not need to worry >about that, but at some point you or somebody else may add a trigger to >that table for whatever reason and you will be getting the incorrect ID >returned to you. I just stick with scope_identity() from the beginning >and never have to worry about it. > >Steve >--- -------- Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
