I usually do it by creating a stored procedure that does the insert and
the
select.
CREATE PROCEDURE MyInsert
@tcCHKLST varchar(20),
@tnINDSTAT int
AS
INSERT INTO TAUX_001
(DSC_CHKLST , IND_STATUS)
VALUES (@tcCHKLST , @tnINDSTAT)
SELECT @@IDENTITY AS 'COD_REQ'
Then my CF code is:
<cfquery name="sel_data" datasource="sys_db" dbtype="ODBC">
EXEC MyInsert 'OBS', 20
</cfquery>
OR
<cfstoredproc procedure="MyInsert" datasource="sys_db">
<cfprocparm type="IN" type="SQL_VARCHAR" value="OBS">
<cfprocparm type="IN" type="SQL_INTEGER" value="20">
<cfprocresult name="sel_data">
</cfstoredproc>
______________________________________________________
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX: 301.424.3696
649 North Horners Lane E-Mail: <mailto:[EMAIL PROTECTED]>
Rockville, MD 20850-1299 WWW: <http://www.euservices.com>
______________________________________________________
> -----Original Message-----
> From: Waldemiro Junior [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 11, 2002 6:27 AM
> 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
