or you can add a trigger to the sql server that runs on insert statements to that table
SELECT @@IDENTITY as newID @llan -----Original Message----- From: Stuart Miller [mailto:[EMAIL PROTECTED]] Sent: 11. januar 2002 14:32 To: CF-Talk Subject: RE: SQL Help Your query will run in Query Analyzer because analyzer uses transact sql. If you're interested in getting the primary key of a record you have just inserted in your CF application, I use <cftransaction>. Like this: <cftransaction> <cfquery name="insert_data" datasource="sys_db" dbtype="ODBC"> INSERT INTO TAUX_001 (DSC_CHKLST , IND_STATUS) VALUES ('OBS' , 20) </cfquery> <cfquery name="sel_data" datasource="sys_db" dbtype="ODBC"> SELECT MAX(COD_REQ) AS ThePrimaryKey FROM TAUX_001 </cfquery> </cftransaction> -----Original Message----- From: Waldemiro Junior [mailto:[EMAIL PROTECTED]] Sent: 11 January 2002 11:27 To: CF-Talk Subject: SQL Help Hi again folks... How can I output a variable that was set within a CFQUERY containing first a insert statement, then a select statement? This is my query: <cfquery name="sel_data" datasource="sys_db" dbtype="ODBC"> INSERT INTO TAUX_001 (DSC_CHKLST , IND_STATUS) VALUES ('OBS' , 20) SELECT @@IDENTITY AS 'COD_REQ' </cfquery> When I try to output COD_REQ, Coldfusion returns an error, but when using the Query Analyzer it works fine... Best regards, Waldemiro Junior ADDTechnologies Web Developer ______________________________________________________________________ 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
