[FX.php List] Multiple find requests

[Dennis Crall]

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