Hello again,

I was just wondering which piece of code is best.

1.) Here I select everything I want from my table and then do something like

<%
while not rs.eof
response.write "<tr><td bgcolor='#C7D5D0'>" & rs("cityname") & "</td></tr>"
rs.movenext
wend
%>

2.) Now I'm thinking about first doing my select and populating an array before even reaching the html tags.
From the array I will then build my html table. Something like...

<%
ssql = select * from table
set rs = cnConnect.execute (ssql)
count = 0
while not rs.eof
''populate my array - lets call it arrName
count = count + 1
rs.movenext
wend
%>

<html>
Now I'll build my html table by "reading" thru the array and using the array variables like arrName(count)


Does this make sense - I was just thinking about it. As far as I see/understand this logic I will now have less "hops" to and from the server when doing it using the 2nd option.


I do not want to use getstring etc, partly because I do not know it well enough and also because I create hyperlinks,change bgcolor etc ont the fly - while running thru my rs.

Any help or suggestions please.

Thanks,
T