Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
[color green]' Assuming we have created a connection, executed some SQL,
' and opened a recordset named rs
' Now we can dump all of the data in rs into an array called rsArray[/color]
rsArray = rs.getRows()
[color green]
' An advantage of getRows() - rs object is no longer needed in memory[/color]
rs.Close
set rs = nothing
[color green]
' If the array is a large grid of data, you identify
' the columns as (rsArray, 1) and the rows as (rsArray, 2)
' A single item in the array is located at rsArray(column, row)[/color]
colStart = LBound(rsArray, 1)
colEnd = UBound(rsArray, 1)
rowStart = LBound(rsArray, 2)
rowEnd = UBound(rsArray, 2)
[color green]
' Loop through all rows of the array and display the data[/color]
Response.Write("<table>" & chr(13))
For row=rowStart to rowEnd
Response.Write("<tr>" & chr(13))
[color green]' For each row we loop through every column[/color]
For col=colStart to colEnd
Response.Write(chr(9) & "<td>" & rsArray(col,row) & "</td>" & chr(13))
Next
Response.Write("</tr>" & chr(13))
Next
Response.Write("</table>" & chr(13))