But the record count does not count how many Insert the SQL has made only
the amount of rows outputted
>From R
-----Original Message-----
From: Eli Shechter [mailto:[EMAIL PROTECTED]]
Sent: 01 December 2000 14:42
To: CF-Talk
Subject: RE: CF Does not like MSSQL7 @@ROWCOUNT
Cold fusion has a problem with writing multiple queries in one CFQUERY, you
could just use the variable #AddInvoices.RecordCount#
-Eli Shechter-
-----Original Message-----
From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 7:31 AM
To: CF-Talk
Subject: CF Does not like MSSQL7 @@ROWCOUNT
Dear All
I have the flowing CF Code
--- START -
<cfparam name="AddInvoices.RowsAffected" default="NOTSET">
<cfquery datasource="#DSNOperaDW#" name="AddInvoices">
INSERT INTO [Images_Invoice_Index]
(Invoice_ID, DirPath)
SELECT CSVTemp.Inv_ID,
CSVTemp.DIR
FROM Images_INVPROJECT_CSVTempTable as CSVTemp
WHERE (Doc_Type = 'I')
SELECT @@ROWCOUNT as RowsAffected
</cfquery>
<cfoutput>#AddInvoices.RowsAffected#</cfoutput>
-- END ---
Now my Output should be a number but I just get my default param back
NOTSET. If I run this query in MS Query Analyzer I will get the following
back
----- START ----
(8 row(s) affected)
RowsAffected
------------
8
------ END -------
Any body know why CF does not pick up the 8 and how I can get it to pick up
the 8
Thanks for your Time
Rif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
