Dim rs, conn ' because you're using option explicit, right?
... define connection etc.
Set rs = Conn.Open("select distinct place_id from locations")
While Not rs.EOF
%><%=rs("place_id")%><%
rs.MoveNext
Wend
OR
[% "$location.place_id " FOREACH location = DBI.query("select distinct place_id from locations") %]
I like TT2
yes, asp sucks baby elephants through a straw (Score:2)
Now I dread seeing a .asp extension on a page I want to use because I know the site will be ill-designed, insecure and likely to not work properly. The kind of idiots who choose ASP are also likely to produce bad html and then claim to have 'designed' for inept exploder.
Mind you I have seen a lot of JSP sites that are almost as
@JAPH = qw(Hacker Perl Another Just);
print reverse @JAPH;