Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Numbered pages

Author  Topic 

mbrunst
Starting Member

1 Post

Posted - 2001-03-16 : 14:04:04
This is more of an asp problem. I have a similar formating to my page number list as seen on SQL team but for some reason i have to put zeros in front of my numbers to make sure they line up.

Example... 001 002 etc...
023 022 etc...
100 101 etc...

Here is how I am doing that. I am just a beginer.
pad="00"
scriptname=request.servervariables("script_name")

for counter=1 to maxcount
If counter>=10 then
pad="0"

end if

ref="<a href='" & scriptname & "?whichpage=" & counter
ref=ref & "&Last_Name=" & replace(Last_Name, " ", "%20") &"&First_Name=" & replace(First_Name, " ", "%20") &"&Co_Name=" & replace(Co_Name, " ", "%20")
ref=ref & "&City=" & replace(City, " ", "%20") & "&State=" &State & "&Zip=" &Zip & "&Status=" &Status & "&Service_Area=" &Service_Area & "&license_state=" &license_state
ref=ref & "&pagesize=" & pagesize & "'>" & pad & counter & "</a>"

response.write ref & " "
if counter mod 15 = 0 then
response.write "<br>"
end if %>


   

- Advertisement -