Page not loaded completely in certain pages using paging??

[lingyi]

Hi,
I got the weird problem here. My web page is using page number to displayed recordset based on one page 10 items. Everythings work fine yet recently when i click either one page randomly, sometimes the page can't loaded completed and stop at half way of loading, pls help if anyone there facing the same problem. thanks

 

[shaddow]

Have u using Acess? ________
George, M

 

[lingyi]

hi,
No, I am not using Access. I using SQL server for my database.

 

[shaddow]

i think that u have an Prev Next and GoTo page.
U mean that when u jump on a random page the page won't load? ________
George, M

 

[lingyi]

hi,
Yes, example if I in page 1 then i will like to view page 4, so when i click page 4, the page doesn't load completed and it stopped.

 

[shaddow]

I had the same problem with my testing example but i foud that my problem was the Recordset variable and the Database connection...
More then shure the problem is from yor database acess code... Check again the code to see if u miss something.
The browser frezes may be caused by an loop witch never stops or from database...
I'll send to you my example if u need and if u are using AbsolutePage this may cause your problem... ________
George, M

 

[lingyi]

Hi,
yes, pls send me a copy of ur example and let me compare with my code. Thanks.
Please send to this email addresss. hoonling.ngoi@frontierforce.com