the subject is a bit misleading. this is my situation:
right now i have my "Gig" database (im a musician) in FMPro. i want
this online so heres what i do now:
1/ i manually run a simple script in FMPro that exports the database to
a file named, say, "gig_export.txt".
2/ i run a small c++ app that i wrote. it automatically imports the
"gig_export.txt" file, parses it and writes an interactive calendar in
javascript inbedded in HTML to a file "calendar.html".
3/ i then manually upload "calendar.html" to my webserver.
the following is what i would like:
1/ i would like the database to be online and represented with an
attractive frontend for a few administrators to edit (booking agents
for my band, manager, myself etc.). this of course is not seen by the
public and can only be accessed with a password.
2/ on my band website, i would like the link that is normally addressed
to "calendar.html" to instead be addressed to "my_c++_app".
3/ hopefully this would dynamically serve my java calendar webpage from
the database on the server.
i understand that i may have to port my c++ app to php. what i dont
understand is why, according to a guy i spoke to last night who runs an
FMPro server, the app cannot speak to the database. he also said it
cant even trigger the script that would export the file to something it
CAN access. he mentioned also that he may be able to write something
that would periodically export the file on the server side (once every
hour) and the exported file would be the target of the php script.
this is absurd to me. someone please help. this is 2006. why cant a
gateway script written in cgi or php simply access a database with the
popularity of FMPro7 and serve a damn webpage. cmon.
do i really have to abandon FMPro and go SQL for this??????