[FX.php List] Re: second find request

[Gjermund Gusland Thorsen]

Do you know FileMaker?

It has the possibility to have several values in one field separated by newline.
$rows = array( 6, 17 );
pseudoFieldRow = implode( "\n", $rows );

ggt667

On 6/28/07, Someone <someone at gagayaya.com> wrote:
> Hi,
>
> It's a flat file. Gjermund.
> SQL equivalent
> SELECT * FROM customer WHERE (section1=102 AND row1=12 AND seat1=14)
> OR (section2=102 AND row2=12 AND seat2=14)
> >
> > I would like to see your relational model in order to make a
> > suggestion for that query.
>
>
> Thanks for the reminder, David. I usually do that
> > Also, keep in mind if you concatenate numbers together, separate them
> > with a delimiter of some sort, otherwise "1123" could mean:
> >
> > Section 1, Row 12, Seat 3
> >
> > OR
> >
> > Section 1, Row 1, Seat 13
>
> Thanks Frank
>
> >
> > On 6/27/07, Someone <someone at gagayaya.com> wrote:
> >> Hi guys,
> >> I want do a multiply find request
> >> (
> >> section1=102 and
> >> row1=12 and
> >> seat1=14
> >> )
> >> or
> >> (
> >> section2=102 and
> >> row2=12 and
> >> seat2=14
> >> )
> >>
> >> In filemaker you would create a second find request
> >> I couldn't figure it out so I create  calculation fields
> >> zw_ticket1 = section1 & row1 & seat1
> >> zw_ticket2 = section2 & row2 & seat2
> >>
> >>         $query->AddDBParam('zw_ticket1', $zw_ticket);
> >>         $query->AddDBParam('-lop', 'or');
> >>         $query->AddDBParam('zw_ticket2', $zw_ticket);
> >>         $queryResult = $query->FMFind();
> >>
> >> Any suggestion for a better method welcomed
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>