the unfortunate thing about that is what
happens when the row count is above 100mil [takes
FOREVER =)], or your doing an
update [no change] =(
-----Original Message-----
From: Bullock, Howard A. [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 3:02 PM
To: 'FARRINGTON, RYAN'
Subject: RE: Win32::OLE
You should execute the following SQL to determine the row count before actually executing the SQL to return data.
Select count(*) from ...
Howard A. Bullock
Global IT Infrastructure
717-810-3584
-----Original
Message-----
From:
FARRINGTON, RYAN [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 3:57
PM
To:
[EMAIL PROTECTED]
Subject: Win32::OLE
ok I have a script that uses Win32::OLE(ADODB.Connection) to connect to a MSSQL 2K database server and I was just playing with the query analyser provided by Microsoft with the client components. When u run a query it returns (x) rows effected [or something like that] I would like to get this returned to the script. Anyone have ideas?>
