Judith,
My bet is that your web developer converts the tables you FTP him to
MySQL tables?
There's code samples on Ed's download site that show how you can use VFP
and ODBC to connect to remote MySQL tables. So - in theory - rather than
generate FTP tables, you could use VFP, an ODBC connection and MySQL
ODBC driver (free) to fill your developers tables with updated content
using a regular VFP program.
The only caveat would be how big your tables are. If you have a ton of
data then you will be limited by your connection to the remote server
and any limitations that your hosting provider places on MySQL update
activity. This may not be a problem if you update your remote MySQL
tables on a daily basis because your daily volume should be
approximately 1/30th your monthly volume.
I think a direct ODBC connection will be much more efficient (time,
money, bandwidth, etc) than creating a web service to update your remote
website.
Malcolm
----- Original message -----
From: "Judith Barer" <judith At star-k .DOT org>
To: profoxtech@leafe.com
Date: Thu, 30 Dec 2004 10:25:30 -0500
X-Suspect-Mail: yes
Subject: web service with vfp 8.0
I have never done any web programming or created a web servcie. I have
developed a VFP 8.0 app that runs in house. Our company also has a web
site
that was developed by an outside consultant who still maintains the site
for
us. Right now once a month I perform a series of queries on our VFP
tables
and we FTP the tables to the web site. When we FTp the tables we
actually
overwrite the live data tables that are being used on the web site.
Until
now this was good enough even though the data was not up to the minute.
Now
we would like to have our web site reflect the most current data. The
first
thought was to upload the data every night. This runs into complications
like I don't really like the idea of overwriting live data and the data
should really be uploaded to a temp directory and then have the web site
down momentarily for processing and then the tables should be
overwritten.
The consultants said that that is very difficult to program. Is that
true?
Anyway I know this is definitely not the best way to do this but I am
the
only programmer in my office and they do not want to spend a lot of
money on
this project.
My other thought is that maybe a better way to do this would be to
create a
web service. If I created a web service to provide the above info ,
would
the web site then be able to be programmed to access the data via this
web
site. Is this very complicated (since I really don't know much about
it) on
my end and on the web site end? The data itself is basically a list of
companies that we certify as kosher and what products they produce.
Thanks for any opinions about the simplest way to get this accomplished.
Judith Barer
Star-K Kosher Certification
Baltimore, MD
410-484-4110
410-653-9294 - fax
www.star-k.org
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
©2004 Malcolm Greene |
