I am using an ADODB.Recordset conne

[davman2002]

I am using an ADODB.Recordset connection to pull data from the server. Problem I am having is that anytime I want to sort the data the page has to go back to the server to pull the information again. Is there a way to store an SQL string in a temp array stored on the users computer?

 

[jemminger]

sounds like you want to sort a table or something on the client-side?

you could go with having asp create an xml data island, then have client-side js populate a table from that data island. i've seen this in IE; not sure if it's cross-browser.

or...

create some client-side js arrays on the server!:[tt]
<script language=&quot;javascript&quot;>
var myArray = [
<%
sComma = &quot;&quot;
while not rs.eof
response.write(sComma & chr(34) & rs(&quot;fieldName&quot & chr(34))
sComma = &quot;,&quot;
rs.movenext
wend
%>
];
</script>[/tt]

then use these arrays to populate a table, etc...
=========================================================
if (!succeed) try();
-jeff