directly connect FMP to CF. It's annoying to the point that, while my
shop does both FMP and CF, we try to avoid linking them when possible.
That said, there are some options:
Ideally, you could port the DB to something like MySQL. If the client
or whoever still needs the FMP interface, there are tricks you can use
to push the data from FMP to the SQL server, but it won't be real-time.
It's worth noting that I've not done this, but my boss has for several
websites.
If this won't work, and if the data is small enough, you could do an XML
dump and run CF directly off of it. Not the best option. I *think*
that you can query FMP and get XML results, but I'm not sure how to do
it. If this is the road you want to go down, I work with one of the
leading experts on FMP and XML.
Finally, you can use something like Instant Web Publishing to do a
poor-man's lookup -- that is, use CFHTTP to call the DB and parse the
data returned by IWP. I've done something like this, but simpler (for
updates/inserts only) and it was a serious PITA.
I hope something in there helps. Good luck.
--Ben Doom
Sangeeta Karmokar wrote:
> Urgent help....
>
> I am using Filemaker Pro server on mac and trying to connect database to
> the coldfusion server and make websites work. how should i go around
> that. I have installed JRun/CFMX in /Applications/jrun4 directory.
>
> I really need serious help..
>
> Regards
> Sangeeta
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
