rows and colums

[mazdaman]

How do I display a result set in, say, 3 colums and as many rows as it takes to show the complete set ? There are not many items in the database - 12.

Cheers

 

[Tarwn]

Create a details page that accepts a size value in the querystring and gets the data from the database based on that value, then in your output you could make the sizes into links that both display the size and use the sze inside the line to your other page, like so:

 sec_row = sec_row & "<td><a href='details.asp?size=" & abc("size") & "'>" & abc("size") & "</a></td>" 'replaces existing size line

now instead of just th size printing out it prints it out as a link to the details page with the size stored in the querystring for retrieval.
Now in your details page you just pull out the data in an SQL statement where the size "(in table) = the value from Request.QueryString("size"). Tada

-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/

 

[mazdaman]

trying that know cheers - also what If i want to get an image from the database how would I place the 'img scr= 'in the following statement, where 'ID' is the name of the image, would I replace the response.write ?

Response.Write "<td>" & abc("ID") & "</td>"
Thanks for ALLLLLL the help ...

If you dont ask, you dont get !!

 

[mazdaman]

by the way the route to the image is '/upload/'.
Ihave used this on a previous page but cannot see how to assemble it with your code Tarwin...
<<img src="/upload/<%=(abc.Fields.Item("pic").Value)%>">

 

[mazdaman]

Ive been messing with the link trying to put fonts and class into but does not work. The detail.asp sits in an IFRAME(called frame) on the same page.

sec_row = sec_row & "<td><a target="frame" href='details.asp?size=" & abc("size") & "'>" & abc("size") & " </a></td>"

This doent work any ideas