What is the right method of making several selectlists dynamically in one page. These lists consist of different SQL queries. I am running into terrible performance problems outputting 2000 item select lists. NO FRAMES !<BR><BR>I know that this is not it:<BR><BR><BR>&#060;Object RUNAT=Server ID=Conn PROGID="ADODB.Connection"&#062;&#060;/Object&#062;<BR>&#060;% Conn.open "abc"<BR>sqlstring = "select * from ABC ORDER BY 123"<BR>Set T = Conn.Execute(sqlstring) %&#062;<BR>output here....<BR>&#060;% Conn.Close %&#062;<BR><BR>Next (on the same page...)<BR>&#060;Object RUNAT=Server ID=Conn PROGID="ADODB.Connection"&#062;&#060;/Object&#062;<BR>&#060;% Conn.open "abc"<BR>sqlstring = "select NAMES from ABC ORDER BY 2123"<BR>Set B = Conn.Execute(sqlstring) %&#062;<BR>output here....<BR>&#060;% Conn.Close %&#062;<BR> <BR>All good solutions are more than welcome...<BR><BR>Thanks,<BR><BR>SL