<cfquery>
set nocount on;
insert stuff;
select @@identity as something;
set nocount off;
</cfquery>
Just did this day before yesterday. :-)
--Ben
Phill B wrote:
> I cant remember how to return the id from an insert. I have searched
> but I can't find what I'm looking for. Not to mention people keep
> buggin me making my job harder than it should be. :-|
>
>
> Anyway, it is some thing like @@identity but I cant remember. Little help?
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187075
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
