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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
