Need to count some records.

[Linkan]

Hello I am working with a sql 2000 db and I dont know how to write get a record cound from the following.
Please advice.

strSQL = "SELECT * FROM vJournal WHERE cus_id=" &GetCusId() &" ORDER BY topic_date DESC"
Set objRs = Server.CreateObject("ADODB.Recordset&quot
objRs.Open strSQL, objConn


/Linkan

 

[foxbox]

I'm not sure i understand your question.

strSQL = "SELECT COUNT(*) FROM vJournal WHERE cus_id=" &GetCusId()

will produce the number of records, but i'm almost sure you have a different problem?
br
Gerard

 

[ToddWW]

This works also...

strSQL = "SELECT * FROM vJournal WHERE cus_id=" &GetCusId() &" ORDER BY topic_date DESC"
Set objRs = Server.CreateObject("ADODB.Recordset&quot
objRs.Open strSQL, objConn

Response.Write "There are " & objRs.RecordCount & " records in this record set."

TW

 

[Linkan]

Thanks, but how do I do if I need to count two different records in the same page. Total records and records for sertain type?

Thanks,
/Linkan