[FX.php List] Search problems

[Gjermund Gusland Thorsen]

Does it make a difference if you do:

... 'non\-fiction', 'eq' ...

?

ggt667

On 7/12/06, Andrew Denman <adenman at tmea.org> wrote:
>
>
>
>
> Just to clarify… the 'eq' parameter is working correctly: it is matching the
> word "fiction", it's just that FM8 sees "non-fiction" as two words.
>
>
>
> You can send any of the special search symbols to FM8 in your search query.
> The '=' is an exact match, '==' is a field content match, '…' is a range,
> and so on.  If you want a for sure match each time, the paranoid way to set
> up the search string is:
>
>
>
> $type = '=="' . $_GET['type'] . '"';
>
> $FMQuery->AddDBParam("Category", $type, "eq");
>
>
>
> It would be like entering '=="non-fiction"' in a FileMaker client.
>
>
>
>
> Andrew Denman
>
>
>
>  ________________________________
>
>
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of
> Kevin Futter
>  Sent: Tuesday, July 11, 2006 11:50 PM
>
>  To: FX.php Discussion List
>  Subject: Re: [FX.php List] Search problems
>
>
>
>
>
>
> On 12/7/06 2:04 PM, "Bob Patin" <bob at patin.com> wrote:
>
> Kevin,
>
>  Here's another approach; change the line
>
>  $FMQuery->AddDBParam("Category", $type, "eq");
>
>  to
>
>  $FMQuery->AddDBparam('Cateogry','=='.$type);
>
>  and you'll get an exact match every time.
>
>
>
>
> Thanks Bob. I actually solved it using something very similar to this; I
> merely changed:
>
>  $type = $_GET['type'];
>
>  to
>
>  $type = "=" . $_GET['type'];
>
>  Works like a charm, though it feels really hacky. Not sure why it works
> with prepending only one "=", but I'm not arguing at this stage. I
> considered the "grab all records and let PHP sort 'em out" approach, but was
> looking for something a little more direct.
>
>  Thanks again to everyone for their suggestions. Great list this one!
>
>  --
>  Kevin Futter
>  Webmaster, St. Bernard's College
>  http://www.sbc.melb.catholic.edu.au/
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
>