page count using oracle

[amisima]

Hi,

I am trying to display 10 results per page and have links to next page. I am getting -1 as a page count. I am using rs.pagecount. I am using Oracle as my database, does the pagecount work with an oracle database?

Thanks,

Amisima

 

[onpnt]

as far as the database is concerned I do not think that is a issue. however the -1 is a very common topic around here. The cause of this is the cursortype and locktype settings.

read this thread and the links to otehr threads on conversations of this same issue
thread333-541817

____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-3811}

http://www.onpntwebdesigns.com