[FX.php List] Re: second find request

[Someone]

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