[FX.php List] Multiple requests with an additional constraint...

[Steve Winter]

Hi Bob,

You're quite correct that (to my knowledge) there isn't a way to do this
with FX using only a 'Find'. 

Couple of options that spring to mind
1. You could write a script to perform the find for you setting global
fields to the values you wish to search on from FX, then calling the
script to do the actual find...

2. perform the find with FX that will produce the smallest set of records,
either the date find or the domain name find, then do the second find in
PHP... so if you did the date find from FX, then ran a loop through the
returned values, pulling out those records which meet the domain criteria
(or the reverse, do the FX find for the domain criteria, then the date
filtering in PHP...


Couple of ideas... YMMV...
Cheers
Steve


>  From reading over the FX documentation that I can find, it looks  
> like there may not be a way to do what I'm trying to do. To make  
> clear my goal, here's what I'm trying to do:
> 
> find any record that contains
> 
> 'string1' or 'string2' or 'string3'
> 
> BUT IT MUST ALSO
> 
> be within a date range '<start>...<end>'
> 
> I can do a search for either the strings or the date range, but I  
> can't seem to do both. When I put in the line to change the logical  
> operator to OR, it then finds all the records with any of the  
> strings, for any dates...
> 
> If there was a way to "re-query" my found set I could do it; I  
> suppose I could go through a convoluted process of marking the found  
> records, but given the # of records involved, this would be an awful  
> solution.
> 
> Does anyone have any solution for this?
> 
> Thanks,
> 
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> 
>    CONTACT US VIA INSTANT MESSAGING:
>       AIM or iChat: longterm1954
>       Yahoo: longterm_solutions
>       MSN: tech at longtermsolutions.com
>       ICQ: 159333060
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list