[FX.php List] Finding ("a" or "b") and "c"

[Dale Bengston]

There is no way to mix and match AND with OR in FileMaker queries via  
the web. This has been a bugaboo since the old CDML days. You could  
accomplish this by sending two separate queries to FileMaker  
(Name="abc" AND Province="a"; Name="abc" AND Province="b") and  
combine the results as you display them.

Hope this helps,
Dale Bengston

On Jun 14, 2006, at 5:39 AM, Jeff Norris wrote:

> I don't believe this is possible directly via the XML query.
>
> To handle more complicated finds you should consider using a script  
> to do all or part of the request(s). If you are using FM7/8, you  
> can use script parameters along with Constrains & Extends to do  
> almost anything, including [soapbox alert] the kinds of basic query  
> optimization that showed up in personal databases in the early  
> eighties but have yet to appear in FM!
>
> - Jeff Norris
>
> Peter Mason wrote:
>> Greetings,
>>
>> I want to perform an FMFind() function call on an FMP version 8 db  
>> similar to the following (simplified) example:
>>     Find records that match...
>>         1) Name="abc"
>>             AND
>>         2) Person lives in (Province="a" OR Province="b")
>>
>> In other words is it possible to combine AddDBParam('-lop', 'or')  
>> with AddDBParam('-lop', 'and') within a single FMFind() function  
>> call?
>>
>> Can anyone tell me whether this is possible and if so how?
>>
>> Help appreciated...
>>
>> _____ (-:|:-) _____
>>
>> Peter Mason
>> ACPM PTY LTD
>> Sydney, AUSTRALIA
>> tel: +61 2 4655 8868
>> fax: +61 2 4655 8868
>> Mbl: +61 409 881 118
>> email: peter at acpm.info
>> __________________________
>>
>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list