Um .. try splitting those up into 2 seperate <cfquery>s inside of a
<cftransaction>. I don't know if it will make a difference, but won't hurt
to try.
<cftransaction>
<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')
</cfquery>
<cfquery datasource="#DSNOperaDW#" name="GetGowsAffected">
SELECT @@ROWCOUNT as RowsAffected
</cfquery>
</cftransaction>
Todd Ashworth
----- Original Message -----
From: "Rif Kiamil" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 01, 2000 8:43 AM
Subject: RE: CF Does not like MSSQL7 @@ROWCOUNT
| But why does CF not pick up the
|
| Select @@RowCount as rowsaffected
|
| Unless in is at the top of the CFQUERY ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
