You could do it like this...
<CFTRANSACTION>
<CFTRY>
<CFQUERY NAME="qryID" DATASOURCE="#Application.DSN#">
SET NOCOUNT ON
INSERT INTO foo (name)
VALUES ('Homer Simpson')
SELECT PrimaryKey = @@IDENTITY
SET NOCOUNT OFF
</CFQUERY>
<CFTRANSACTION ACTION="Commit"/>
<CFCATCH>
<CFTRANSACTION ACTION="Rollback"/>
</CFCATCH>
</CFTRY>
</CFTRANSACTION>
<CFOUTPUT>
Inserted ID = #qryID.ID#
</CFOUTPUT>
HTH
-----Original Message-----
From: Scott Van Vliet [mailto:[EMAIL PROTECTED]]
Sent: 17 February 2002 19:22
To: CF-Talk
Subject: Dynamically Obtaining IDENTITY Column
Hey All.
Does anyone out there know of a way to dynamically grab the identity
column from a table in a select statement?
Example:
<CFQUERY NAME="queryname" DATASOURCE="dsn">
SELECT @@IDENTITY_COLUMN
FROM TABLE_NAME
</CFQUERY>
Where "@@IDENTITY_COLUMN" would be the function to obtain the value of
the identity column.
TIA.
----
SCOTT VAN VLIET
BRD.WRKS INTERACTIVE
[EMAIL PROTECTED]
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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
