I have a database that contains characters such as a ":" or "/", etc. I have a search page that contains a pop up menu containing the exact options available. For example, Body/Cap/Housing: Brass. When I perform the search with these characters it passes on the following:

db.cgi?db=default&uid=default&Body_Cap_Housing=Body%2FCap%2FHousing%3A+Brass%2C+Nickel+Plated&view_records=View+Products

I don't know if dbman is reading the Body%2FCap%2FHousing........ correctly. It does not bring back any records with this information, when I know there are records with these parameters. Any ideas on correctly this situation would be appreciated. Thanks.

The browser automatically converts non-alpha/numeric characters to their "hex" equivalent (or a + in the case of a space). Without the conversion, the URL won't work when you do the search.

When the script parses the form, it re-converts the characters, so they should be as they were entered originally. I'm not sure what the problem is, but at least I was able to explain why it's doing what it's doing.


------------------
JPD

Thanks JPD. As usual this was my problem. Some of the data was entered incorrectly. Everything seems to work fine now. Thanks for your help.