[FX.php List] Re: second find request

[Someone]

Thanks for your input Andrew

Frank

> The easiest way is the same way as in FileMaker: two find  
> requests.  You
> will do two FX.php calls to the FileMaker database and then you can  
> combine
> the two results.
>
> An alternative is to find all of your records (or a reduced set  
> that you can
> do in a single request to FileMaker) and then reduce the found set  
> through
> PHP.  Going this route will depend on how many records you have and  
> how much
> data you're pulling.
>
> Another alternative, though frowned upon, is to run a script to do the
> finds.
>
> A fourth alternative that might work is to have a concatenated  
> field that
> you search on.  Since you can change the operator (SetLogicalOR()  
> function
> in FX.php) you should be able to do the search as long as you are  
> searching
> on one field.  You can't have a mix of AND and OR searches in one  
> FX.php
> request, which is why you need two if you need to search on more  
> than one
> field.
>
> This is a FileMaker limitation through the web; you would have to jump
> through the same hoops if you used the FileMaker PHP API or sent XML
> requests directly to the WPE.  Also, I have never had to do one of  
> these
> searches (yet), so this is information pulled from previous  
> discussion on
> this list as well as some theorizing.
>
> Andrew Denman