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

[Gjermund Gusland Thorsen]

Well, the simplest way is to make a new table,
with a related field, f ex named query of type text in whixh is
related to Seedling Source TN
with a portal with the data you need to know.

Then perform an fmnew() to this temporary query table using the following data

$q->AddDBParam('query', 'TN2891' . "\n" . 'TN3531' . "\n" . 'TN3827' );

ggt

2008/5/12 Troy Meyers <tcmeyers at troymeyers.com>:
> 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
>
>
>
> _______________________________________________
>  FX.php_List mailing list
>  FX.php_List at mail.iviking.org
>  http://www.iviking.org/mailman/listinfo/fx.php_list
>