Going Goofy Over Error - Posted (869 Views)
Advanced Member
Carefree
Posts: 4224
4224
Here's some code I wrote for a small school's registrar. If I don't search for a name, it displays properly. If I do, it freezes and then displays rows of edit/trash icons, followed by blank image place holders and more edit/trash icons, etc. until it times out.
Fixed that bug. Taking another approach on the last one.
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Snitz Forums Admin
ruirib
Posts: 26364
26364
Does the page submit, when you try to change it? Does the code receive the desired page number correctly?
Posted
Advanced Member
Carefree
Posts: 4224
4224
Yes, it submits from the bottom (2) and receives the page number correctly; but the top page changer doesn't function (except it will receive the correct page number when changed with the bottom). Unfortunately, the data displayed never changes; consistently reads from the first record.
Posted
Snitz Forums Admin
ruirib
Posts: 26364
26364
Regarding the first issue, I see one single call to Paging2 (line 778). If you have two dropdowns, shouldn't there be two? Also, this call just uses the value 1 for the parameter passed to the function.
Regarding page changes, what database are you using? This seems a modded topic.asp, and I have seen you changed the paging code associated with SQL Server / Access. I wonder why you would do that?
Posted
Advanced Member
Carefree
Posts: 4224
4224
There's another call at about 867 using 2 (which works, except as noted above). There's nothing from topic.asp in it - I used the page change routine from members.asp but ran into a couple of odd results when searching for students (which is where the changed Access/Sql routine comes in).
Oh yes, forgot to specify. I'm testing on Access will be in MySql when implemented.
Posted
Snitz Forums Admin
ruirib
Posts: 26364
26364
At 867 what you have is the definition of a subprocedure, not a call to one.
Posted
Advanced Member
Carefree
Posts: 4224
4224
lines 873-881 - should have been 876 not 867

Code:

If MaxPages > 1 Then
Response.Write "<table border=""0"" align=""left"">" & vbNewLine & _
" <tr>" & vbNewLine
Call Paging2(2) Response.Write " </tr>" & vbNewLine & _
"</table><br />" & vbNewLine
Else
Response.Write " " & vbNewLine
End If
Posted
Snitz Forums Admin
ruirib
Posts: 26364
26364
Not in the code that you posted...
Posting code like this, it's never the best option. I may not have copied it properly, but I have 913 lines, plus a few comments.
 
You Must enter a message