Re: Need a recordcount in ADO recordset
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Wed, 30 Aug 2006 14:56:58 -0400
TechBoy wrote:
Hello.
I have the following code that connects to an Oracle database and
pulls records from 3 tables via complex SQL code. These tables are
very large and only a portion of rows from each are pulled for the
result.
One of the system requirements is that I need to get a recordcount of
rows in this recordset from the SQL call & output that value to a text
log file later.
Do you need to do anything with the actual data? or is your goal simply
to get a count? if so,
strSQL = "Select count(*) FROM " & _
"(<SQL Code that works from three very large tables>) as data"
The code runs and returns approx 570k rows when I run the SQL code in
an external Oracle utility. In my code though, just doing a
"rs.recordcount" in the debug window yields "-1", not the real row
quantity.
http://www.aspfaq.com/show.asp?id=2193
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Follow-Ups:
- References:
- Need a recordcount in ADO recordset
- From: TechBoy
- Need a recordcount in ADO recordset
- Prev by Date: Need a recordcount in ADO recordset
- Next by Date: Re: Calling stored procedure from ASP with ADO
- Previous by thread: Need a recordcount in ADO recordset
- Next by thread: Re: Need a recordcount in ADO recordset
- Index(es):
Relevant Pages
|
|
