Exact match not an exact match

[pendle666]

Hello

In a recent post

http://www.tek-tips.com/viewthread.cfm?qid=1564491&page=1

I asked about using a drop-down for Exact Match or Like, depending on what the user is searching for. I wanted these options to be disabled until something was entered in the appropriate field.

However, if searching for the surname Smith and choosing Exact which is the default, I get all the Goldsmith's first, it ought to be the Smith surname only listed.

The code is below. Is there something else which needs to be done to the code, or could it be something to do with the actual database?

regards

Pendle


<tr>
<td>
<label for="Surname"><b>Surname</b>
</td>
<td colspan="2">
<input name="Surname" id="Surname" onChange="document.getElementById('surname_dropdown').disabled=false;"/>
</td>


<td>
<select name="surname" id="surname_dropdown" disabled="true" >
<option value="=" selected>Exact Match</option>
<option value="like">Like</option>
</select>
</td>
</tr>
<tr>
<td>
<label for="Name"><b>Name</b></td>
<td colspan="2">
<input name="Name" id="Name" onChange="document.getElementById('name_dropdown').disabled=false;"/>
</td>

<td>
<select name="name" id="name_dropdown" disabled="true">
<option value="=" selected>Exact Match</option>
<option value="like">Like</option>
</select>
</td>
</tr>

 

[vacunita]

This only your presentational code. We'd need to see the code that actually perfomrs the search
Selecting something on a Drop down means nothing if you don't use it in your search.

s this a Database? Are you searching in another script in what language? If not Javascript perhaps it may be more adequate to post in the forum for the language you are using to perform the search.


----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.