Drop down menu

[smash81]

Hello,
I have tried to get data from a database and then populate a drop down(select) box with the data.The menu is in a form which i am submitting and the action ASP displays the data selected from the menu.The problem is that the data displayed is only the first word of the selected data.
Example if "hello world" is selected, only hello gets displayed.
The code i have used for the select is
while not rs.eof
response.write &quot;<option value=&quot; & rs(0) & &quot;>&quot; & rs(0) & &quot;</option>&quot;
rs.movenext
wend

Please help me on how i can get the whole option selected.
Cheers

 

[iowtech]

What actually comes out when the page is served, if you do view source from your browser?

Does the whole word appear between the option tags?

 

[kevink]

Try enclosing the option value in single quotes i.e.

response.write &quot;<option value='&quot; & rs(0) & &quot;'>&quot; & rs(0) & &quot;</option>&quot;

If that doesn't work, then try using server.URLEncode to encode the option value:

response.write &quot;<option value='&quot; & server.urlencode(rs(0)) & &quot;'>&quot; & rs(0) & &quot;</option>&quot;

HTH,

Kevin