> The article did mention trouble coming from the database
> itself if ones insert caused a trigger to be fired. Then the
> @@identity could return
> the generated key from what ever the trigger created.
Yes, and it does. Having had that unpleasant experience once, with an older
application, convinced me to switch to using SCOPE_IDENTITY(). Granted, not
everyone uses triggers, or ones that involve an identity column on another
table, but better safe than sorry.
-Leigh
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:326786
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
