I have noticed a difference when searching my database by city. It works fine with IExplorer 5.5 but not with Netscape 4.7.
[Background] I am using 2 dababases. The first contains ID, city, state and country. The second contains all the data, name, street, phone, etc. The first search by state lists all the cities for that state with active records. The second search is inititated by choosing a city. This is where the problem exists.
A normal search using DBMAN for San Diego would look like this: &City=San+Diego
But searching from an HTML page sends this result:
IExplorer: &City=San% 2 0 Diego (% 2 0 is between the 2 names without the spaces. Had to put them in so it would show up in this post)
The result is correct, finding only the records with San Diego as City.
Netscape: City=San Diego (no characters between names)
The result in incorrect. Due to the space the search results includes any city with 'San'; San Francisco, San Jose, etc.
If I do a search with IExplorer for &San Diego it automatically adds the code for space as part of the search word.
Does anyone see how I can make the search work for both browsers? I've tried it with whole words on and off.
I've considered using long/short displays but I don't want San Diego listed for every record in the first search.
To see the search go to: http://ortho-k.net/doctors.htm
David L Davidson, O.D.
Improve your vision without surgery
[Background] I am using 2 dababases. The first contains ID, city, state and country. The second contains all the data, name, street, phone, etc. The first search by state lists all the cities for that state with active records. The second search is inititated by choosing a city. This is where the problem exists.
A normal search using DBMAN for San Diego would look like this: &City=San+Diego
But searching from an HTML page sends this result:
IExplorer: &City=San% 2 0 Diego (% 2 0 is between the 2 names without the spaces. Had to put them in so it would show up in this post)
The result is correct, finding only the records with San Diego as City.
Netscape: City=San Diego (no characters between names)
The result in incorrect. Due to the space the search results includes any city with 'San'; San Francisco, San Jose, etc.
If I do a search with IExplorer for &San Diego it automatically adds the code for space as part of the search word.
Does anyone see how I can make the search work for both browsers? I've tried it with whole words on and off.
I've considered using long/short displays but I don't want San Diego listed for every record in the first search.
To see the search go to: http://ortho-k.net/doctors.htm
David L Davidson, O.D.
Improve your vision without surgery