[ic] Coordinate search problem

Mike Heins interchange-users@icdevgroup.org
Thu Apr 3 22:47:01 2003


Quoting Jamie Neil (jamie@versado.net):
> I'm trying to customise the foundation search component to allow optional
> searching within a selected category or manufacturer. I've got it partially
> working, but it doesn't seem to be behaving properly :(
> 
> The search box has two drop down lists for product (catagory) and brand
> (manufacturer) which are built dynamically from the corresponing tables, and
> a text box for typing in search strings.
> 
> If the text box is left empty and a catagory and/or manufacturer is selected
> then the search works as expected (all products in that catagory from that
> manufacturer). If both catagory and manufacturer are set to "all" (option
> returns "") then all items are returned.
> 
> However, as soon as anything is entered into the text box (e.g. Penny) then
> I get "Sorry, no matches for  x|y|z." where x is the catagory, y is the
> manufacturer and z is the search string.
> 
> If I then change the search field for the text box from "*" to
> "description", it seems to start working. So if I select "Nails", "All
> Manufacturers" and type in "Penny" it comes back with the 3 items with
> "Penny" in the description. But if I type in "pen" it doesn't work, even
> though I have substring matching switched on.
> 
> I've also tried many other combinations of options with varying degrees of
> success, but I cannot get it to reliably find all (or sometimes any)
> matching items.
> 
> Is this a bug or is there something wrong with my syntax (or logic)?

Try the third search field as:

    <INPUT TYPE=hidden NAME=mv_search_field VALUE=":*">

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

I don't want to get to the end of my life and find I have just
lived the length of it. I want to have lived the width of it as
well. -- Diane Ackerman