Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

page count using oracle

Status
Not open for further replies.

amisima

Programmer
Jun 11, 2003
13
0
0
CA
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
 
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

____________________________________________________
[sub]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[/sub]
onpnt2.gif
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top