[FX.php List] Multiple requests with an additionalconstraint...

[Gjermund Gusland Thorsen]

I mean that you should try the function: FXQuery

Gjermund

On 10/31/06, Steve Winter <steve at bluecrocodile.co.nz> wrote:
> Hi Gjermund,
>
> I'm sure this is a very profound contribution to the thread, but what do you
> actually mean...??
>
> Cheers
> Steve
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Gjermund Gusland
> Thorsen
> Sent: Tuesday, 31 October 2006 6:57 p.m.
> To: FX.php Discussion List
> Subject: Re: Re: [FX.php List] Multiple requests with an
> additionalconstraint...
>
> Try: FXQuery
>
> On 10/31/06, Bob Patin <bob at patin.com> wrote:
> > Thanks Steve; as you can see, I've been working late tonight...
> >
> > That's pretty much what I did, but it ended up being easier to query
> > for the strings first, then to cull the foundset using the date range.
> > It's too bad there isn't a bit more flexibility; it would've been so
> > easy if I could've either done a "requery" of the foundset or done a
> > mixture of AND and OR in one query.
> >
> > Chris, are you listening? :)
> >
> > What do you think, is that doable?
> >
> > Thanks for your help Steve! Now to sleep!
> >
> > Bob
> >
> >
> > On Oct 31, 2006, at 12:09 AM, Steve Winter wrote:
> >
> > > Bob,
> > >
> > > I'd be inclined just to use a foreach through the returned set, so
> > > you'd end up with something like;
> > >
> > > foreach($returnedData as $key -> $value) {
> > >   if($value['domainName'][0] == 'domain 1' ||
> > >      $value['domainName'][0] == 'domain 2' ||
> > >      $value['domainName'][0] == 'domain 3') {
> > >   // output whatever you want here }}
> > >
> > > Cheers
> > > Steve
> > >
> > >> Steve,
> > >>
> > >> Thanks for the suggestions; both very good... your 2nd suggestion
> > >> sounds like a good one.
> > >>
> > >> So let's assume I did the date search first (it would probably
> > >> reduce the found set more than the other search. Would I then have
> > >> to loop thru the records to reduce them, or is there another
> > >> mechanism in PHP that would search the array for me?
> > >>
> > >> I know how to loop thru the found set, but that seems slower than
> > >> perhaps some other type of query might be. My knowledge of PHP
> > >> extends just far enough to get around in FX, but other than some
> > >> fairly minor string manipulation and date parsing, I'm a
> > >> lightweight with PHP... :)
> > >>
> > >> So if you have a suggestion on another way to cull the found set
> > >> other than a loop, I'd appreciate any insights...
> > >>
> > >> Thanks again,
> > >>
> > >> Bob
> > >>
> > >>
> > >> On Oct 30, 2006, at 10:47 PM, Steve Winter wrote:
> > >>
> > >>> 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
> > >>
> > >>
> > >
> > >
> > > _______________________________________________
> > > FX.php_List mailing list
> > > FX.php_List at mail.iviking.org
> > > http://www.iviking.org/mailman/listinfo/fx.php_list
> >
> > _______________________________________________
> > FX.php_List mailing list
> > FX.php_List at mail.iviking.org
> > http://www.iviking.org/mailman/listinfo/fx.php_list
> >
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>