[ic] Coordinated Search Problem

Mathew Jones matt@booksellersolutions.com
Thu, 21 Dec 2000 14:01:55 -0800


The author and title fields may or may not have a value, depending on what the
user inputs. The main issue is  getting the coordinated search to search all
category fields.

thanks

Mat

Steve & Patti Getzinger wrote:

> Mathew Jones wrote:
>
> > Based on a previous mailing list response by Mike to a similar question
> > regarding coordinated searches, I tried this code below.
> > If only a category value is submitted the returned result are matched
> > from all fields in DB not just category fields.
> > Am I  missing something simple?
> > Maybe you have a suggestion Mike?
> >
> > Thanks
> >
> > Mat
> >
> > <input type=hidden name="st" value="sql">
> > <input type=hidden name="co" value="1">
> >
> > <input type=hidden name="sf" value="author">
> > <input type=text name="se" value="">
> > <input type=hidden name="sf" value="title">
> > <input type=text name="se" value="">
> > <input type=hidden name="sf" value=":category1:category2:category3">
> > <select name="se">
> > <option>Art
> > <option>Fiction
> > </select>
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
>
> try reversing the order of your se's and sf's but why are you searching
> for nothing in title and author couldn't you just eliminate that part of
> the code? and what about value= in the select and options. You must have a
> value to retrieve a value. What people see isn't good enough you must tell
> the form what the values are. I am rusty here but something like
>
> <SELECT NAME=se VALUE="">
> <OPTION VALUE="art">Art</OPTION>
> </SELECT>
>
> A coordinated search means you are searching for this in that and from
> there searching only those returns for this2 in that2 You are searching
> for NULL "" in author and NULL "" in title so unless you have empty
> entries in the author and title fields that line up you will always return
> nothing (NULL) And now we start looking through our NULL for doesn't
> matter because we killed all returns with the first request of the series.
>
> Ok for all the perfectionists it might not go that way but it is easily
> human understood that way :)
>
> Steve
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users