Hi List,
I recently upgraded from SQLServer7 to 2k and the @@identity in the
code below now returns a null string. Anyone know why this might be
happening?
~~~~~~~~~~~~~~~~code block~~~~~~~~~~~~~~~~~~~~~~
<!--- insert user info --->
<cfquery name="insertPeople" datasource="#dsn#">
set nocount on
insert into people
(password, username)
values
('something', 'testuser123456')
SELECT lastid = @@identity
set nocount off
</cfquery>
<!--- capture the peopleid from the previous query --->
<cfset thepeopleid=#insertPeople.lastid#>
<!--- insert associated user detail --->
<cfquery name="insertDetail" datasource="#dsn#">
insert into people_detail
(peopleid, firstname, lastname)
values
(#thepeopleid#, 'firstname', 'lastname')
</cfquery>
~~~~~~~~~~~~~~~~end code block~~~~~~~~~~~~~~~~~~~
Thanks for the help.
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
DaVita Inc.
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
