I have 300 records in my MS SQL 2000 db that I want to pull onto a page which is fine.

However, what I want to do is have 3 columns (for example) with 100 in each - how would I go about doing this?

usually I'd just use:

strSQL = "SELECT * FROM tbl_MyTable"

etc and then loop through the records.

thanks

Adam

Do you mean you want a result set that has 3 columns and 100 rows in each?

I really don't understand your question, are you trying to implement paging?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Yes, well, it might not be 3 columns of 100 rows but I'm using that as an example to show the kind of thing that I need.

Is that paging?

thanks

Adam

Ok. So, what you are saying is that you have 300 rows of data and you will want those records split into x number of columns. (So if it was 5 columns you would want 60 rows of data per each column)

If this is the case you could do it a number of ways. First you could set up paging and display X amount of records based upon y. (num_of_records/num_of_pages = num_of_records_per_page)

You could write some logic like this in your asp page (psuedo code):

Dim sHTML
Dim i
Dim num_cols
Dim num_rows
Dim totalRows

i = 0
totalRows = Select max rows from database (I assume 300 is not a constant value)
num_cols = Request some input (I will use 3)
num_rows = totalRows / num_cols

sHTML = "<tr><td>"
While data object reads
    if i <= num_rows then
       sHTML =sHTML & object[datacolumn] & "<br>"
       i = i + 1
    elseif i > num_rows
       sHTML = sHTML & "</td><td>" & object[datacolumn] & "<br>"
       i = 1
  sHTML += "</td></tr>


<table>
<%=sHTML%>
</table>

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Thanks very much.

This is what I am looking for,