[ic] Restricting search to certain fields
Kevin Walsh
kevin at cursor.biz
Sat Mar 13 12:41:25 EST 2004
Interchange User [interchange at framework.cx] wrote:
> I am running IC 5.0 with a text products database. When I run the
> code below, it ends up searching all database fields (artist, title,
> and genre). So for example, if I type "stone" in the Artist field
> (hoping to find Rolling STONEs), among the results will be Bob Dylan's
> "Everybody Must Get STONEd." What am I missing that will restrict my
> searches to the desired field only?
>
> I have the following code, adapted from the demo at
>
> http://www.icdevgroup.org/i/dev/docfly.html?mv_arg=icdatabase06%2e04
>
You went straight to the code and missed the text - specifically
this part, right at the top of the page you quoted:
Interchange will do a complete range of tests on individual columns
in the database. To use this function, set mv_coordinate to Yes
(co=yes in the one-click syntax).
Which means that you need this in your form:
<input type="hidden" name="mv_coordinate" value="yes">
Going directly to the code isn't a bad thing, but the text sometimes
helps when the supplied code appears to fail. :-)
--
_/ _/ _/_/_/_/ _/ _/ _/_/_/ _/ _/
_/_/_/ _/_/ _/ _/ _/ _/_/ _/ K e v i n W a l s h
_/ _/ _/ _/ _/ _/ _/ _/_/ kevin at cursor.biz
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/
More information about the interchange-users
mailing list