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
