[FX.php List] Finding multiple records from multiple values for same field

[Troy Meyers]

Nick,

What did you mean by:

> FMFindQuery();  // you would have to create add the -findquery piece in
> the FX.php file. pretty easy to add

...?

-Troy



> I didn't see this mentioned, but with FileMaker server 9 and FX.php you
> can use:
> 
AddDBParam('query', '(q1);(q2);(q3);(q4);(q5)');
AddDBParam('-q1', 'myNum');
AddDBParam('-q1.value', 1);
AddDBParam('-q2', 'myNum');
AddDBParam('-q2.value', 2);
AddDBParam('-q3', 'myNum');
AddDBParam('-q3.value', 3);
AddDBParam('-q4', 'myNum');
AddDBParam('-q4.value', 4);
AddDBParam('-q5', 'myNum');
AddDBParam('-q5.value', 5);

FMFindQuery();  // you would have to create add the -findquery piece in the
FX.php file. pretty easy to add
> 
> -Nick
> 
> On Fri, May 9, 2008 at 3:22 PM, Bob Patin <bob at patin.com> wrote:
> 
> > I need to set up a query that searches a single field for any of a set
> of > numbers (in other words, multiple find requests). > > I might have
> 2 values, I might have 20; so I need to find > > 1 > 2 > 3 > 4 > 5 > >
> in the "myNum" field > > and return all matched records. Would I need to
> do a separate query for > each search value, and concatenate the
> resulting arrays, or can i do this in > a single query? > > Thanks, > >
> Bob Patin > Longterm Solutions > bob at longtermsolutions.com >
> 615-333-6858 > http://www.longtermsolutions.com > FileMaker 9 Certified
> Developer > Member of FileMaker Business Alliance and FileMaker TechNet
> > >  CONTACT US VIA INSTANT MESSAGING: >     AIM or iChat: longterm1954
> >     Yahoo: longterm_solutions >     MSN: tech at longtermsolutions.com > 
>   ICQ: 159333060 > > -------------------------- > Contact us for
> FileMaker hosting and programming for all versions of > FileMaker > PHP 
> 
> CDML 
> 
> Full email services 
> 
> Free DNS hosting 
> 
> Colocation 
> 
> > Consulting > > _______________________________________________ >
> FX.php_List mailing list > FX.php_List at mail.iviking.org >
> http://www.iviking.org/mailman/listinfo/fx.php_list >