Jeff - The second: select the ID value when you don't know the name of the identity column...
Is this even possible? Thanks! -----Original Message----- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 11:42 AM To: CF-Talk Subject: RE: Dynamically Obtaining IDENTITY Column Scott - do you mean the identity value of a newly inserted record, or to select the ID value when you don't know the name of the identity column? -----Original Message----- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 2:22 PM 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] � ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
