Need help modeling ASP page

Hi,

My current ASP page requires about 7 seconds to load (because the DBMS is Access 2000), which my group agrees is too long. I have tried to use the GetString() method to store the entire data table, which should speed things up. Unfortunately this page is no simple data table:

http://epics.ecn.purdue.edu/jds/asp/members.asp

Thus, I haven't been able to get GetString() to work like I want. See current results:

http://epics.ecn.purdue.edu/jds/asp/members_test.asp

That's right - I have to turn the second page into something that looks similar to the first page, by using GetString(). Can anyone offer some advice on using GetString for complex tables, or offer suggestions on how to improve loading speed of my first page? Any help would be great.

p.s. the query takes less than one second to run in Access.

well, you can certainly do it with get rows as you previously did.

After you do ar=rs.getrows()

access each value as
ar(1,0) for the first value in row 1
ar(2,0) for the second value in row1

ar(1,1) for the first value in row 2
ar(2,1) for the second value in row 2

ar(1,2) for the first value in row 3
ar(2,2) for the second value in row 3


and write the values where you need 'em.