At 09:12 AM 5/12/2005, you wrote:
>At 09:00 AM 5/12/2005, you wrote:
> >CFQUERY will not return back a new identity either, well depending on the
> >database chosen it will not without a second cfquery.
>
>
>This has sometimes worked in the past:
>
>declare @new_id INT
>insert into table (a, b)
>values ('#a#', '#b#'
>select @new_id as new_id
Sorry, skipped a step:
(note, this is SQL-2000 syntax)
declare @new_id INT
insert into table (a, b)
values ('#a#', '#b#')
set @new_id = Scope_Identity()
select @new_id as new_id
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:11:2616
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
