[FX.php List] Multiple find requests

[Jordan Sandford]

I guess you could do
//all your AddDBParams here
$foundset1=$query1->FMFind()

//all your AddDBParams here
$foundset2=$query2->FMFind()

and then concatenate (or push) $foundset1['data'] with 
$foundset2['data'] . If you want you could store the concatenated 
arrays into a new array.

-Jordan


On Jan 18, 2005, at 4:21 PM, Dennis Crall wrote:

>
> This has been a popular question recently. One I am facing myself. I 
> believe
> the answer is that you can not use the XML interface to query the 
> database
> using two logical operators.
>
> Now, I am wondering if anyone has used an ODBC connection in PHP to 
> connect
> to FileMaker. We're considering a hybrid solution where the site is
> primarily driven by FX except for the one query that needs multiple
> operators.
>
> Is this feasible? What ODBC Driver Manager are you using with the PHP?
>
> Any help is appreciated. Thank you,
>
> Dennis Crall
> ITS-Academic Technologies
> University of Iowa
>
>
> On 1/18/05 12:34 PM, "Kevin Drennan" <kevin at santafe.edu> wrote:
>
>> I need to do a query that contains both a logical AND and a logical 
>> OR.
>> Is it possible to do multiple find requests in FX like you can when
>> you're in find mode in Filemaker via the Requests -> Add new request
>> menu item? To paraphrase the query I'm looking for all records in my
>> table where program_name = 'Math 101' AND advisor_1 = 'John Doe' OR
>> advisor_2 = 'Jane Smith'
>>
>> Any advice would be much appreciated.
>>
>> Thanks,
>> Kevin
>>
>> _______________________________________________
>> 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
>