[FX.php List] FX.php and SQL queries against FMSA 8

[Chris Hansen]

Jason,

Of course I have; I built the thing =)  Granted, I should echo what  
others have said about performance, but you can do some cool things  
(e.g. updating every record that matches specified criteria, etc.)   
And, I didn't find performance to be THAT much slower than accessing  
FileMaker via the XML interface.  In the case of ODBC, your DSN is  
entered using SetDBData(<DSN>).  Seemed the most logical use of FX  
syntax for an ODBC connection.

Just FYI, setting everything up on Mac OS X (as opposed to Windows)  
can be hairy (or was when I did it) because of differences in the way  
that the ODBC drivers are set up in the OS versus PHP.  (That may  
have changed by now, though.)

Best,

--Chris Hansen
   FileMaker 7 Certified Developer
   Creator of FX.php
   "The best way from FileMaker to the Web."
   www.iViking.org


On Apr 4, 2006, at 3:52 PM, Jason H Awbrey wrote:

> Hello all,
>
> Has anyone used FX.php to query FileMaker via the ODBC interface?  
> It seems as though I would need to specify a DSN somewhere but  
> don't see anywhere I would be able to do that. Does anyone have a  
> simple example they could share that could get me pointed in the  
> right direction?
>
> Cheers,
> Jason
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>