[FX.php List] Boolean-type searches

[Derrick Fogle]

You could also create a calculation field in FM that ends up creating  
a hash of the data - a different result for each possible  
combination. Then searching on a single field will get your results.  
Just make sure the field is stored/indexed, or it will be ... ... ...  
s ... l ... o ... w.

On Sep 25, 2007, at 1:50 PM, DC wrote:

> is there a FAQ? this should be question #1. also, is there a list  
> archive? ah yes, there it is:
>
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> oh shit. it's not searchable.
>
> well....
>
> there is no simple way to do this. choose your poison.
>
> 1. write a script in FMP and run the script from FX.php. the result  
> set after the script runs should be your set.
>
> 2. return one set of results from a wider search and cull the  
> results in a foreach loop in PHP.
>
> 3. return two sets of results and merge/cull them in PHP.
>
> 4. do a combination.
>
> hey guys, did i forget anything?
>
> dan
>
> Carl Anderson had written:
>> Good day, list.
>> I apologize if this is academic, or is written in some obvious  
>> place that
>> I've overlooked.
>> I'm trying to query a database with two fields, let's say: Points and
>> Status.
>> I'm looking to search for something like the following (pseudo- 
>> codish):
>> Status = 1 AND (Points = 0 OR Points = "")
>> Sadly, I have no clue how to do this with FX.php--seems if I do a  
>> logical
>> OR, then I end up with:
>> Status = 1 OR Points = 0 OR Points = ""
>> Can someone point me in the right direction?  I really need it to be
>> X=1 AND (Y=0 OR Y="")
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list


Derrick Fogle
derrick at fogles.net