OK, that output is like this:
Starting Data like this:
6087|195|25|000.96|COMMODI
Your table output:
|---------------------|
|6087 |
|---------------------|
|195 |
|---------------------|
|25 |
|---------------------|
|000.96 |
|---------------------|
|Commodity |
|Inventory |
|---------------------|
|CAN |
|---------------------|
|APPLE SLICES, |
|Commodity 6/#10|
|Cans |
|---------------------|
This continues all the way across the screen to the right.
Joe
Main Topics
Browse All Topics





by: fritz_the_blankPosted on 2006-09-05 at 12:32:37ID: 17458342
I can help you with this, but we have to do it a step at a time as I can't test here.
First step:
arrRows = objRS.GetRows()
objRS.Close
set objRS = Nothing
Response.Write("<Table Border=1 cellpadding=2 cellspacing=2>" & VBCrLf)
for i=0 to UBound(arrRows,1)
Response.Write("<TR>" & VBCrLf)
for j=0 to UBound(arrRows,2)
Response.Write("<TD>" & arrRows(i,j) & "</TD>")
next
Response.Write("</TR>" & VBCrLf)
next
Response.Write("</Table>")