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

[Dale Bengston]

Steve, I think you're right - in general, filtering the results is  
probably better than making two FX queries to FileMaker.

-Dale

On Jun 14, 2006, at 7:41 AM, Steve Winter wrote:

> Or you could search for Name="abc" then use PHP to filter out those  
> that do
> not match "a" or "b",
>
>   foreach($recordSet['data'] as $key => $value) {
>    if($value['Province'][0] == "a" || $value['Province'][0] == "b") {
> 	// put the record here
>    }
>  }
>
> However if you're working with large record sets this will  
> dramatically
> increase the amount of data that is returned, which probably leaves  
> Dale's
> suggestion as the most practical...
>
> Cheers
> Steve
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dale  
> Bengston
> Sent: Wednesday, 14 June 2006 10:35 p.m.
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Finding ("a" or "b") and "c"
>
> 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
>
> _______________________________________________
> 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