I know how to use @@identity to select the last inserted record right under
an insert but how do I display that id of that record?
<cfquery name="" datasource="gunledger" dbtype="ODBC">
INSERT INTO dbo.distrib(compname, phonenum, address, address2, city, state,
zip, fflid, expires)
VALUES('#compname#', '#phonenum#', '#address#', '#address2#', '#city#',
'#state#', '#zip#', '#fflid#', '#expires#')
select @@identity as 'identity'
</cfquery>
How do I output the identity????
Josh
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
