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

[Troy Meyers]

Roger,

I'm able to do it, but I didn't use SetLogicalOR(). Here's how:

$familygroup_find->AddDBParam('-lop','or');
$familygroup_find->AddDBParam('Seedling Source TN','=='.'TN2891');
$familygroup_find->AddDBParam('Seedling Source TN','=='.'TN3531');
$familygroup_find->AddDBParam('Seedling Source TN','=='.'TN3827');

This also works if you specify a different field for each find term, but of course it's OR rather than AND if you do.

-Troy


> This is something that I have tried (and failed) to do previously.  It
> has  been my understanding that even using SetLogicalOR()  you cannot
> query the  same field more than once so that the following does not
> work:
> 
> $query->AddDBParam('fieldname', 'something',       'eq');
> $query->AddDBParam('fieldname', 'somethingelse','eq');
> 
> When I have done this only the 'somethingelse' value seems to be
> returned!
> 
> Roger