> > @@IDENTITY (or 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?
You won't be able to use @@IDENTITY with CFINSERT. I would recommend that
you avoid CFINSERT and CFUPDATE anyway, and just write your own SQL.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
