About Paging and joined tables

[agustri]

Dear forum,
I have a problem to display record from sql server and asp.
there are the record:
id city code
1 jak a
2 jak b
3 jak c
4 jak d
5 jak e
6 bdg f
7 bdg g
i want to display perpage 5 record.
like this
jak a
b
c
d
e

and then to second page
bdg f
g

thks before.
Best regards,

agus

[Spudhead]

I'm confused. You mention a table join, but only list one table. And as far as I understand, your post isn't about "paging" in the traditional sense: you just need to select records based on the city. Right?

[agustri]

oh,
im' so sorry that the table just one.
now my problem has been complete..ok
thks for your attention.


regards,



agus