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

[Steve Winter]

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