469,610 Members | 1,855 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

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

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!!!
Dec 12 '06 #1
2 1101
shweta123
692 Expert 512MB
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
Dec 12 '06 #2
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
Dec 12 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

16 posts views Thread by Raxit | last post: by
12 posts views Thread by Philipp.Weissenbacher | last post: by
2 posts views Thread by James Calivar | last post: by
5 posts views Thread by Dave | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.