Rows/Line Counter

jmss66 · July 2nd, 2003, 12:27 PM

How do I know what line or row I am printing on? I need to show data from a table in two columns, 26 rows. Please let me know how to go about coding this display layout.

Thanks,
Judy Sese

Greg Griffiths · July 2nd, 2003, 05:03 PM

Why not just use a counter variable and increment it as you move down the table at the end of each row ?

jmss66 · July 3rd, 2003, 10:20 AM

I am sorry I was not clear on my question. I guess what I am trying to as is the syntax or code to start printing on the first line of the 2nd column.

This is the scenario:

Records 1 -26 should be displayed/printed in column 1. Records 27 - 52 needs to be printed in column 2. I used a <table> to display columns 1 and 2. My problem is column 2 is displaying below column 1. I need it to be displayed beside colum 1.

Which brings me back to my question, how to display records in two colums. That is why I was asking about line number so I can store the first records line counter and when record 27 is read I can tell it to go to column 2 same line counter as record 1. I do not know how to go about this problem. If someone can help me please.

Thanks

NotNowJohn · July 3rd, 2003, 10:49 AM

You can use recordset's GetRows in order to get all records at once. Then you can process all records in the matrix variable...

Code:

mat=rs.GetRows
' if you have more columns than you can calculate columns number
'm=UBound(mat,1)+1
'and rows number
'n=UBound(mat,2)+1
;In you case n=52
n=52

Response.Write "<table>"
For i=0 to n/2-1 
    Response.Write "<tr><td>"  &  mat(0,i) & "</td>"
    Response.Write "<td>"  &   mat(0,i+26) & "</td></tr>"
Next
Response.Write "</table>"

...but the Soon is eclipsed by the Moon

pgtips · July 4th, 2003, 04:12 AM

LOL, I just posted pretty much the same solution to this problem in the ASP Databases forum. Hey, NotNowJohn, do you think its a case of "great minds think alike", or is it "fools seldom differ"?
;)

Quote:

quote:Originally posted by NotNowJohn
You can use recordset's GetRows in order to get all records at once. ..

NotNowJohn · July 4th, 2003, 11:05 AM

Hehe
Sometimes I am glad to see that someone else use the same way, but sometimes I enjoy in the discussions about the solution's road.:)
Next time when I see that your name is under the last posterâs name of the forum, I will skip it.:)
In these forums there is appreciably possibility for "duplicate answers" cause a lot of users post their questions in several forums, sometimes under the different captions.

Regards,
NNJ

...but the Soon is eclipsed by the Moon