[FX.php List] Re: second find request

Dale Bengston dbengston at preservationstudio.com
Fri Jun 29 08:53:31 MDT 2007


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



More information about the FX.php_List mailing list