View Single Post
  #6 (permalink)  
Old April 22nd, 2004, 09:05 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

It's because you don't have your While Wend stuff in a server side ASP block. Change it to this:
Code:
<select name="Table">
<% while not RS.EOF %>
<option value="<%=RS("TABLE_NAME")%>"><%=RS("TABLE_NAME")%></option>
<%
  RS.MoveNext
  wend
%>
</select>
Alternative, create one ASP code block that uses Response.Write statements to write out all the <option> elements. This will perform a little faster.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: No Hope by Motorpsycho (Track 4 from the album: Wrenched)

Reply With Quote