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
TeeJay on 2003-09-03T18:15:11
I wasted nearly a year hacking ASP sites for a bunch of cowboys. It was probably the least productive and useful environment I have ever dealt with and that includes Lotus Notes!
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 crud as ASP sites - O2's website currently won't show your bill in mozilla because the HTML is broken.
