View Single Post
  #2 (permalink)  
Old April 21st, 2004, 08:23 PM
rodmcleay rodmcleay is offline
Friend of Wrox
Points: 2,376, Level: 20
Points: 2,376, Level: 20 Points: 2,376, Level: 20 Points: 2,376, Level: 20
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , Australia.
Posts: 596
Thanks: 1
Thanked 3 Times in 3 Posts
Default

I am not sure about the query itself as I have never tried to list the tables but I can see that there is some errors in the creation of the dropdown box.

Try
Code:
<select name="Table">
while not RS.EOF
<option value="<%= RS("TABLE_NAME")%>"</option>
RS.MoveNext
WEND
</select>
The difference being that the options are added in a loop, as well as there was a syntax error in you server side script tag.

======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================
Reply With Quote