dbRecordCount

[pbms]

I am trying to do a record count using the following syntax.

MyDb.ASPdb
response.write("RecordCount=" & MyDb.dbRecordCount)

The subsequent grid show me 2 records, but the dbrecordcount = 0 on the page.
Any ideas?

Thanks,
Gianni

[Frank]

Seems like you are using classic ASP-db. Show some simple NWIND code to illustrate the problem.


FK

[pbms]

Yes, using Classic ASPdb Pro
This is my actual code.

Dim Mydb
Set Mydb=Server.CreateObject("ASP.db")
MyDb.dbColor = "White,Blue,LightSkyBlue,Black,LightGrey,,fals e"
Mydb.dbDSN = Session("ConnectionString")
MyDb.dbDBType = "SQL" ' It is an SQL database

SQL = "Select * from vw_rep_IncomingAccountableLog "
MyDb.dbSQL = SQL
MyDb.dbGridInc=20
MyDb.dbMode = "grid"
MyDb.dbGridHideFlds = "0,1,2,3,6,12,13,14,15"

MyDb.dbOptions = "HeaderFontTag=Size=1,CellFontTag=Face=Arial Size=1"
Mydb.dbNavigationItem = "Next, Prev, Download"
Mydb.dbNavigationIcon = "std"
MyDb.dbSuppressMsg = true
MyDb.dbImageDir="../../images/"
MyDb.ASPdb
response.write("RecordCount=" & MyDb.dbRecordCount)