[ic] Calling all search gurus

[Ed LaFrance]

At 05:54 PM 08/09/2001 -0400, you wrote:
>Quoting Ed LaFrance (edl@newmediaems.com):
> > Hi all -
> >
> > Using IC 4.6.5 with MySQL.  Need to do a form-based search, something like
> > this:
> >
> > mv_search_field="field1,field2,field3,field4"
> > mv_searchspec="foo"
> >
> > mv_search_field="field5"
> > mv_searchspec="1"
> >
> > I need to find all products which have /foo/ in any of the corresponding
> > fields, AND do not have '1' in the other field.  I thought this would be a
> > simple coordinated search:
> >
> > <input type=hidden name=mv_searchtype value=db>
> > <input type=hidden name=mv_coordinate value=yes>
> >
> > <input type=hidden name=mv_search_field 
> value="field1,field2,field3,field4">
> > <input type=text name=mv_searchspec value="foo">
> > <input type=hidden name=mv_column_op value=rm>
> > <input type=hidden name=mv_numeric value=0>
> >
> > <input type=hidden name=mv_search_field value="field5">
> > <input type=hidden name=mv_searchspec value=1>
> > <input type=hidden name=mv_column_op value="!=">
> > <input type=hidden name=mv_numeric value=1>
> >
> > ..but it does not work.  The problem is the multiple search fields in the
> > first group - if I search just one field, it works fine - multiple fields
> > completely break the search.  Somehow I need to tell IC that "foo" in
> > field1 OR field2 OR ... etc. is acceptable for the first group - it 
> appears
> > to be applying 'AND' logic to the list of fields instead.
> >
> > Perhaps this can be done with an SQL statement? But I would rather not 
> rely
> > on searching products.txt, I prefer to search the db directly.
>
>Can't really be done with 4.6.x other than a hack which kills performance,
>or by manually counting the index position of the fields and doing:
>
>  <input type=hidden name=mv_search_field value=":4:6:7:8">

Not pretty, but it works for now, and the structure of the products table 
is not something which changes frequently.  Thanks, Mike!

- Ed L.


>Shades of Minivend 2.
>
>If you are waiting for a reason to update to 4.8, that would be  it, for
>you can do:
>
>  <input type=hidden name=mv_search_field 
> value=":field1:field2:field3:field4">
>
> >
> > Thanks in advance for any suggestions!
> >
> > - Ed L.
> >
> >
> >
> > ===============================================================
> > New Media E.M.S.               Software Solutions for Business
> > 463 Main St., Suite D          eCommerce | Consulting | Hosting
> > Placerville, CA  95667         edl@newmediaems.com
> > (530) 622-9421                 http://www.newmediaems.com
> > (866) 519-4680 Toll-Free       (530) 622-9426 Fax
> > ===============================================================
> >
> > _______________________________________________
> > interchange-users mailing list
> > interchange-users@interchange.redhat.com
> > http://interchange.redhat.com/mailman/listinfo/interchange-users
>
>--
>Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
>phone +1.513.523.7621      <mheins@redhat.com>
>
>Nature, to be commanded, must be obeyed. -- Francis Bacon
>_______________________________________________
>interchange-users mailing list
>interchange-users@interchange.redhat.com
>http://interchange.redhat.com/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================