[FX.php List] Query question

[Bob Patin]

Troy,

It's really not practical though; my clients need to be able to  
login, do different reports on the fly, and I really don't want to  
try to do this with a script. For one thing, the searches are going  
to be mix-and-match using 4 or 5 fields in addition to the field that  
can contain as many as 30 or 40 different catalog numbers.

I'm afraid the FOREACH that Dan suggested is going to be my only  
option, but I certainly don't like it much.

Another thought I just had though, would be to use an EDIT to edit a  
key field to contain the catalog values, and then retrieve the portal  
results that get triggered when I set this key field. I may try that;  
any thoughs on that idea, guys?

Bob


On Jan 25, 2007, at 5:29 PM, Troy Meyers wrote:

> Bob,
>
> As you know I'm new to PHP, but wouldn't the best plain FileMaker  
> way to do this be to do a 'Find' with the fields that are common to  
> all first, and then do a single 'Constrain Found Set' with the  
> catalog number queries each as its own record/request (i.e. ORing  
> them)?
>
> If that works in FileMaker, wouldn't there be a way to set this up  
> in PHP?
>
> -Troy
>
>
>> This is funny: when I did a search of the old FX emails from the    
>> past,
>> I found that I'd asked this exact question once before, and no    
>> one had
>> a solution other than to re-query for each different situation.
>>
>> My problem is that I need to create a report where there might be 20
>> different catalog numbers, and then the searcher might also include a
>> city or state or zip code. I hate to think that I'd have to do 20
>> different queries to build a single table of results...
>>
>> I'd sure love to hear a solution for this one...
>>
>> Bob Patin
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list