| 0 |
Subject: ASP Paging
Posted by: tledge
- [401150297] Thu, Jan 27, 2005, 16:15
Anyone:
I am looking for an easy way to add in my paging numbers on the bottom with the first 5 numbers showing as 1 | 2 | 3 | 4 | 5 | >
with the > showing after the 5th page. then back if it beyond it like, < 6 | 7 | 8 | 9
10 | > I can't seem to find anywhere how to do this. Can someone help me?
Here is my query in SQL
strSql = "select " & _
"id, " & _
"username, " & _
"date_uploaded, " & _
"file_desc, " & _
"file_name, " & _
"file_location, " & _
"file_size " & _
"from Files where 1=1 order by date_uploaded desc"
|
| 1 | Code Cracker
ID: 20491621
Fri, Jan 28, 2005, 23:51
|
Is this ASP or ASP.NET? How are you displaying your results? Is it in a datagrid or as just HTML? Are you databinding to a control?
If you aren't databinding you could store all the results in a hidden field and decide which ones to display on the client-side when the user clicks on a number using Javascript.
I don't really understand your query. It is:
"SELECT id, username, date_uploaded, file_desc, file_name, file_location, file_size FROM Files WHERE 1=1 ORDER BY date_uploaded DESC"
Is there a field in your table named 1? If not then the WHERE clause will fail.
Any additional info you can give would help.
|
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|
|