record count

[discusmania]

Hello...
I've problem to count records in my table. I've try this

dim recount
objrec.movelast
recount=objrec.recordcount
objrec.movefirst

but error returns:

Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
The rowset does not support fetching backwards
/hr/dbs/news.asp, line 25

Please Help
TQ

 

[NickBulka]

you don't need to retrieve all your records to get a count. try this query:

select count(*) from myTable

nick bulka

 

[discusmania]

Thanks for the fast reply, I'm not very familiar with SQL . I've try to do the query but the problem is , I want to hold the amount of records in a variable. How to do it?

 

[culshaja]

If you use the following variation of te query:

select count(*) as numrows from mytable

then you can get at the result using

myvar = myrecordset("numrows")

James

James Culshaw
jamesculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

 

[NickBulka]

Just to clarify, the results of the query will be a recordset with one record, and one field, which contains the number of records.

you could also retrieve the value by getting myrecordset(0)


nick bulka

 

[ruupy]

CalShaya,

MANY MANY THENX!!!!

,....i've been dancing around this simple solution for an hour.
I tried to declare a variable and storing the count in it,..no result trying to extract it in ASP.
I tried to use the size of a recordset in ASP but i missed certain details,...


ThenX
RuupY

 

[Jonax]

BTW:
The original error message probably means that you have opened your recordset as Forward Only...

 

[link9]

and could be solved by setting the .cursorType to something other than the default...

rs.cursorType = 3 'adOpenStatic

would work just fine.

Just for future reference, in case you need both data and .recordCount

 

[culshaja]

Just thought I'd mention though, that if you call a Stored Procedure from a command object and the connections cursor location is set to server then you cannot override the recordset cursor type.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305