[FX.php List] How do I specify an "Exactly Equal To" search?

[Andrew Denman]

That is my experience as well, that those two are the same.  I tend to add search operators to the search term though, so someone looking at it who knows FileMaker can quickly see what the search is doing.

Andrew Denman

From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Tim 'Webko' Booth
Sent: Monday, November 14, 2011 2:07 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] How do I specify an "Exactly Equal To" search?


Jon's original answer is quite correct because this isn't a PHP comparison which is being run but an FMP one... you can use any/all of the 'usual' FMP comparison operators by prepending them (almost) as Jon showed.

Jon was using the FM Studio syntax, where the find is set up as an array, and then performed.


The correct syntax for fx.php is

            $find->AddDBParam('_kf_userID',"==".$userID);

Just checking - in my experience, that's the same as:

            $find->AddDBParam('_kf_userID',"=".$userID, 'eq');

Where the third part is the FM operator (eq, bw, lt)... Correct?

Cheers

Webko
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20111114/5ad5bc85/attachment.html