469,927 Members | 1,763 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

display 5 records across, unlimited rows

Greetings,

I have a page displaying records in a table across but there are too
many records to display and they run off the page, SO I thought I could
show five columns with an unlimited number of rows. I'm stuck though.
I've never done that before. I don't know where to start. Any thoughts
would be very helpful.

I don't need paging as I can display all records on one page, keeping it
simple.

Here's my recordset:
<%set rsAll=objConn.execute("select * from qyProd where catalogid>0
order by designer_name")%>

Thank you in advance.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #1
2 1832
Basically, you want to start a <tr> at the beginning, then put a </tr><tr>
at each five step after, and then follow that up with a final </tr>.
Additionally, you'll probably want to determine the difference between the
final record count and the next closest multiple of five so that you can
complete the final row with as many <td>&nbsp;</td>'s as necessary. Here's
some sample code here.

http://www.aspfaq.com/show.asp?id=2247

Ray at home

"Debbie Davis" <dd@clickfocal.com> wrote in message
news:Oi****************@TK2MSFTNGP11.phx.gbl...
Greetings,

I have a page displaying records in a table across but there are too
many records to display and they run off the page, SO I thought I could
show five columns with an unlimited number of rows. I'm stuck though.
I've never done that before. I don't know where to start. Any thoughts
would be very helpful.

I don't need paging as I can display all records on one page, keeping it
simple.

Here's my recordset:
<%set rsAll=objConn.execute("select * from qyProd where catalogid>0
order by designer_name")%>

Thank you in advance.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #2

Thanks Ray, I really appreciate the reply. I'll take a look. many
thanks again.
dd
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Damon Grieves | last post: by
9 posts views Thread by thomasp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.