>SCOPE_IDENTITY in newer versions) to refer to the new identity column value.
So, after doing the cfinsert, I tried using @@IDENTITY within the CF, but I'm not sure how to reference it. I'm using MS Sequal Server so it should be there. Does it work ok with a cfinsert or must I do a cfquery?
I've done some searches in the archives must they always use it within a query so it's just sql at that point. I saw one use of it in CF, but it was in a named query and I'm doing a cfinsert. Should I switch?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
