rs.RecordCount

[snowboardr]

Hey I am unable to get recordcount to work in mysql and ASP, when I try it gives me back a -1 anyone know how to solve this? I also try SELECT column1,column2,count(*) as dbCount FROM ...

that returned 1 less record then there was. I would rather get recordcount working, because I want to do some paging.

www.vzio.com
ASP WEB DEVELOPMENT

 

[sleipnir214]

Have you applied the appropriate advice from this page:

http://www.mysql.com/doc/en/MyODBC_clients.html

?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[theScien]

To return the total number of records you could use the COUNT() like this:

strSQL = "SELECT COUNT(*) AS rowTotal FROM tbl_FOO"

If you have set RS to be your record set, retrive the value with: RS("rowTotal&quot

If it still returns -1, use: Option=16384 in your connection string.

If you haven't heard of it, then you most likely don't need it.
---------------------------------------------------------------------

http://www.mylittlehost.com

---------------------------------------------------------------------