FMP and ColdFusion - can they work together?

[SarahF]

Hi guys,

Can I use FMP and ColdFusion together?? Does FMP use SQL?

Thanks!

Sarah

[Garry Claridge]

FMP uses SQL with ODBC.

Garry

[SarahF]

Sorry, so was that a yes?

[Garry Claridge]

Does ColdFusion do SQL through ODBC?

Garry

[SarahF]

Yes, it does.

How do I see the tables in Filemaker Pro to query them with SQL?

[Garry Claridge]

You use the FM "Define > Database" menu items to get to the tables, data-definitions and relationships.

Good Luck.

Garry

p.s. ColdFusion may be using Java. FM also has a JDBC driver.

[Garry Claridge]

I just checked the Macromedia site and found a list of supported databases:

http://www.macromedia.com/software/coldfusion/productinfo/systemreqs/fp_frameset.html

Unfortunately, FM is not in the list. However, there maybe other ways for ColdFusion to talk to FM.

All the best.

Garry