[FX.php List] Boolean-type searches

[Alex Gates]

ooooo look!  searchable fx.php archives.

http://www.google.com/coop/cse?cx=013867382578033190853%3Axht3ywlmfpc



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
>