January 31, 2002 at 5:12 am
Hi. It's taken me a couple of days to learn to populate a dropdown with a table and pass it to a search page. But the problem I have is the space between words, ie Audio Equipment, Card System. The item has a partner field that relates to the time between electrical testing, which doesn't get found.
Here's my code
Response.Write "<form action=""ddquery.asp"" method=""GET"">"
Response.Write "<select name=""Stock""><option selected>--Select Item--"
do While Not RS.EOF
Response.Write "<option value=" & RS("Item") & ">"
Response.Write RS.Fields("Item")
rS.movenext
loop
I'm retesting at the moment, so here's the 'query' page.
SearchText = Request.Querystring("Stock")
response.write (SearchText)
Thanks in advance.
Jon
January 31, 2002 at 5:40 pm
Not sure I'm clear on your problem. Is your problem in returning the query or populating the drop down with the correct values?
February 1, 2002 at 2:43 am
I can get the query to populate the dropdown, just not pass to the query page.
February 1, 2002 at 4:54 am
You are not properly delimiting your vlaue in the option so say the value is FLU SEASON it would appear in source as
<OPTION VALUE=FLU SEASON>FLU SEASON
and when passed it sends only FLU. To fix this make the following change:
Response.Write "<option value=" & RS("Item") & ">"
to
Response.Write "<option value='" & RS("Item") & "'>"
now it will source in html as
<OPTION VALUE='FLU SEASON'>FLU SEASON
And when parsed the beginning quote and end set it off. Finally when sent, the data is sent as FLU SEASON.
Hope this helps.
February 1, 2002 at 5:57 am
Cheers mate, that bloody apostrophe gets me every time!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy