adoRS.Open "select * from table_name"

numField = adoRS.Fields.Count
response.write("Number of Filed of table_name = "&numFiled)

my question is....

how will i know how many rows are there in table_name?
is there a

numRows = adoRS.Rows.Count

any help with this?...... tnx

You could either do it in a select statement:
(where "ID" is your key field)

Or you could try:
Or the brute force way:

Seppuku,

Why do you have to do a MoveLast, then Movefirst before doing the count, in your second example?

because he hasn't specified the recordset cursor type or the database he is going to so he doesn't know what how the recordcount property will behave...

If you move to the last record in most cases you can be sure your recordcount will be accurate.

Right. I was playing it safe.

Using the recordcount property of the recordset object you can find out the number of records in a table.

Using the recordcount property of the recordset object, you can find out the number of records in a table.

That has already been stated asdf.

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = MyConnectionString
Conn.Open
Set RS = Server.CreateObject("ADODB.RecordSet")
RS.CursorLocation = adUseClientBatch
SQL = "SELECT * FROM MyTable"
RS.Open strSQL, Conn, adOpenStatic
TotalRowNumber = RS.RecordCount
...
Set RS = Nothing
Set Conn = Nothing

The bottom line is:

• If you want to know the number of rows in a table, use SELECT COUNT(*) FROM tablename.
• If you have issued a query and want to know how many rows are in the result, you must use MoveLast before examining the Count. The reason is that the SQL-engine might deliver the first page of results to you before it has actually finished the entire query.

If you can possibly avoid it, don't go for that record count. Not unless you need it for some purpose other than giving the user an "interesting" number. Either (a) you are running a redundant query (and an expensive one at that), or (b) you're forcing the user to wait for full query completion (and... forcing the DBMS to actually complete it) ... all to produce, "an interesting but expensive number."