[ic] Coordinate search problem

[Jamie Neil]

> -----Original Message-----
> From: interchange-users-admin@icdevgroup.org
> [mailto:interchange-users-admin@icdevgroup.org]On Behalf Of Mike Heins
> Sent: 04 April 2003 04:45
> To: interchange-users@icdevgroup.org
> Subject: Re: [ic] Coordinate search problem
>
>
> 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=":*">

Thanks, that seems to do the trick!

Is this documented anywhere (other than the mailing list archives now ;))?
I've been through all the docs I could find on the icdev and rtfm sites and
googled relentlessly (3am)

All the searches work now except one - if I leave all the search fields
empty ("") I want it to return _all_ products, instead it comes back with
"Sorry, no matches for | | .". The foundation search component seems to use
a search term "* ne 1" - I assumed this was to handle null searches, but it
doesn't seem to work in my modified search.

--
Jamie Neil

>
> --
> 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
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>