Got an odd problem that is totally

[lewis33]

Got an odd problem that is totally foreign to me. Got some queries that search via two drop down lists and these access SQL Server. Everything is working correctly except for two of the values in the drop down lists. After stareing at this for a while, I think I may have isolated the problem. In one of the drop down lists, I have a product "Diet Plus" that relates to a product code of "DP+". When the user selects that one.......it produces no results from the SQL Server data though I know the query is correct per the data.

Then, in the specialty drop down list, I have a few entries with that produce &quot;The page cannot be displayed&quot; errors. I noticed that all of these entries have the '&' in them like <option value=&quot;Vets & others</option> in the HTML source code someone wrote for me.

Any ideas on this topic (I know cliched) but appreciated for the rest of my breathing days. Thanks from Cleveland.

 

[mwolf00]

Try using the &quot;post&quot; method to send the form rather than the &quot;get&quot; method which uses the URL to send the querystring. The other option is to server.URLencode the values (asp) so that the &quot;+&quot; is changed to &quot;%20&quot; or whatever the URL equivalent is....

Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048
Tek-Tips Best Practices: FAQ183-3179