2. ASPRunnerPro General questions
  3. runtime error when clicking page number
This topic is locked

runtime error when clicking page number

 		3/14/2006 12:30:05 PM
ASPRunnerPro General questions
S
 semleon author

Hello,

I'm using mysql db with ODBC connection. Site works perfectly (inluding searches). I have about 900 records in total. (only one table at the moment).

Problem is, when I try to click directly to a page (5 or higher, including "last") I get the following error:
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'setupRs.Move'
/ftt/MSR/core_list.asp, line 765
I can click directly to pages 1-4 with no problem. Any Ideas?
Sergey Kornilov admin 3/15/2006

Hi,
it seems that this error appears over MySQL ODBC driver.

To make your pages working please open core_list.asp file and replace

setupRs.MoveFirst

if nPageSize (mypage-1) > 0 then setupRs.Move nPageSize (mypage-1)



with

setupRs.MoveFirst

if nPageSize (mypage-1) > 0 then

for ddd=1 to nPageSize (mypage-1)

setupRs.MoveNext

next

end if
S
 		semleon author 3/15/2006

SUCCESS! Thank you. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=8558&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />