[FX.php List] Re: second find request

[Gjermund Gusland Thorsen]

Good Dale, but please use the keys to combine the arrays instead of ifs...

ggt667

On 6/29/07, Dale Bengston <dbengston at preservationstudio.com> wrote:
> In the city/country case, I would execute two separate finds via FX
> and aggregate the returned results.
>
> Dale
>
> On Jun 28, 2007, at 8:30 PM, Someone wrote:
>
> > hi Dale,
> > I didn't design the database
> > How about a different example
> >
> > find customers where
> > city=Ottawa and country=Canada
> > or
> > city=Madrid and country=Spain
> >
> > In filemaker we create 2 find request
> > How's this done in FX.php
> >
> > Frank
> >
> >> Hi Frank,
> >>
> >> Let's take a step back to what the purpose of this query is. Are you
> >> retrieving user-selected records? Are you retrieving available seats?
> >> Perhaps there's a way to retrieve a larger set of records and filter
> >> for the couple you need, or extract them in some other way.
> >>
> >> Dale
> >>
> >> On Jun 28, 2007, at 4:26 PM, Someone wrote:
> >>
> >>> HI Gjermund,
> >>> Yes I know Filemaker
> >>> Another Filemaker developed the Filemaker app
> >>> Therefore contact table has the following fields
> >>> Section1 , Row1 ,Seat1
> >>> Section2 , Row2 ,Seat2
> >>>
> >>> I just show you this sql statement hoping to clarify what search I
> >>> wanted to do
> >>>>> SQL equivalent
> >>>>> SELECT * FROM customer WHERE (section1=102 AND row1=12 AND
> >>>>> seat1=14)
> >>>>> OR (section2=102 AND row2=12 AND seat2=14)
> >>>
> >>> Just want to have 2 find request with 3 fields search on each
> >>> request
> >>> I haven't seen a better way than the calculation method described
> >>> before
> >>>
> >>> ???
> >>>> It has the possibility to have several values in one field
> >>>> separated by newline.
> >>>> $rows = array( 6, 17 );
> >>>> pseudoFieldRow = implode( "\n", $rows );
> >
> > _______________________________________________
> > 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
>