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

[Gjermund Gusland Thorsen]

I'm not sure if it will work, but I would try to use a portal to do the job.

ggt667

On 6/14/06, Dale Bengston <dbengston at preservationstudio.com> wrote:
> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>