How do I display data on a web page using arrays instead of 'Do...While...MoveNext...'?

 This FAQ describes the process of displaying data on a Web page through arrays instead of the traditional Recordset method.

While opening a Recordset object and then using a 'Do While Not objRS.EOF ... ' Loop and iterating through each row in the Recordset works well for displaying arrays, there are advantages to using a special Recordset method called GetRows(). GetRows() reads the contents of the Recordset into a two-dimensional array. To display the Recordset data, simply iterate through this array.

While the syntax involved in using the array-based approach is a bit more confusing that simply looping through the Recordset via a 'Do While Not objRS.EOF ...' Loop, the main motivation behind using GetRows() is performance.