Gossamer Forum
Home : Products : DBMan : Customization :

Certain records not being found

Quote Reply
Certain records not being found
Hi Guys,

I have a strange problem. I have a databsse which has names, surname, etc. The names and surnames were all originally entered in uppercase, which is not really a problem except that certain records are just not found when a search is done unless you enter the keyword in UPPERCASE. The real funny part is that it seems limited to one field only i.e the surname.

An example would be:
keyword: porter
Result: Not Found

keyword: PORTER
Result: GARTH PORTER ETC.
plus all other porter's in the database

keyword:garth
Result: GARTH PORTER ETC.
plus all other porter's in the database

I tried editing the database record and even changed the case, no luck. The reord can only be found by entering the keyword in UPPERCASE.

Help please.

Thanks in advance

Greg


Quote Reply
Re: Certain records not being found In reply to
One potential problem I saw in your Source Code of http://www.rummage.co.za/listing.html
is that you did not specify a FIELD NUMBER for the sort by (sb) value.

You have:

Code:
<input type="hidden" name="sb" value="Name">

It should be:

Code:
<input type="hidden" name="sb" value="1">

Replace the "1" with the number of field you would like to sort by.

Also, you have the "keyword" INPUT statement incorrectly formatted.

You have:

Code:
<input type="text" size="15" name="Search" maxlength="255">

It should be:

Code:
<input type="text" size="15" name="keyword" maxlength="255">

If you are not using a "keyword" search, but for a particular field, then replace keyword with the NAME of the field you are having people search by.

Hope this helps.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us
Quote Reply
Re: Certain records not being found In reply to
Hi There,

Thanks for the reply. I will look at what you suggest. I did manage to solve the problem though. JPDenni (I think) posted a mod to the script to slice out 'and' 'or' etc. This was slicing the OR from the name Porter whcih caused incorrect results.

I purposely use the field search. What I have done is created a search field that essentially contains copies of all the fields we require to search so that we can search within a category. By default the 'keyword' search results in copies of itself into every field which defeats the poiunt of a category search.

Thanks for the assistance so far.
Greg