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

[Dale Bengston]

Hi Bob,

If there are other search criteria, I would search on those and then  
filter the results based on the presence of one or more of your  
numbers below.

Dale

On May 9, 2008, at 3:22 PM, Bob Patin 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