hi! newbie here! want to ask about dropdown list...

[darkcat02]

hello... i wanted to ask how can i get the value on dropdownlist in asp from a database... i actually know what the code is... but the problem is when i display the value it has different characters... for example i selected "Mhaey G." then the value that displayed is "Mhaey+G%2E "... How can i get rid of this characters?? + represents the space and the %2E represents the period/dot... the values i selected were from the database... please help me.. i need an answer as soon as possible... thanks in advance!!! mwaahh!!!

[shweta123]

I am not getting how are u filling the dropdown?

This can be the one way u can do it
<Option id="Select1" name="select1">
<%
sql="Select fieldname from ...................."
set rs=con.Execute(sql)
while not rs.EOF%>
<OPTION><%=rs("somefield")%></OPTION>
<% rs.MoveNext
wend%>

Shweta

[darkcat02]

THANK YOU VERY MUCH!!!! MMWWAAAAHHHH!!!!!!! =D

I am not getting how are u filling the dropdown?

This can be the one way u can do it
<Option id="Select1" name="select1">
<%
sql="Select fieldname from ...................."
set rs=con.Execute(sql)
while not rs.EOF%>
<OPTION><%=rs("somefield")%></OPTION>
<% rs.MoveNext
wend%>

Shweta