This is off topic .. but I know you lot are always keen to
help!  

I maintain a freeware app (using DBISAM) which updates a
webpage every 30 secs or so as each (sports) competitor
performs.

The app builds the html page which is approx 2-3k then FTPs
it to replace the previous one.

On broadband it runs well .. but some venues only have
dialup or a weak G3 signal so it can take several seconds
to upload and this is the problem.    If a surfer's
browser refreshes during the upload .. blooey, they get a
blank page and assume the service has failed (when all they
need to do is Refresh).

So I am looking for advice/pointers/references for a means
of minimising or eliminating this 'blooey window'.

The web server is Apache 1.3x so an ISAPI.dll is not a
solution (as far as I know).  Freeware app, so low cost
solutions are preferred - my time is free!  D6SP2. DBISAM
4.22

Any pointers?

(I am a little surprised that FTP servers appear not to
cache uploads then apply them server-side upon completion
.... or have I missed something?)

Malcolm
--

Malcolm wrote:
> This is off topic .. but I know you lot are always keen to
> help!  
>
> I maintain a freeware app (using DBISAM) which updates a
> webpage every 30 secs or so as each (sports) competitor
> performs.
>
> The app builds the html page which is approx 2-3k then FTPs
> it to replace the previous one.
>
> On broadband it runs well .. but some venues only have
> dialup or a weak G3 signal so it can take several seconds
> to upload and this is the problem.    If a surfer's
> browser refreshes during the upload .. blooey, they get a
> blank page and assume the service has failed (when all they
> need to do is Refresh).

Tried to upload it with a different name and rename it afterwards?

Ralf

Ralf Mimoun wrote <<

  
  Tried to upload it with a different name and rename it
  afterwards?
  
  Ralf
>>

Just tried this .. and it is very odd.
I uploaded Test1.txt and Test2.txt
Then I renamed Test2.txt to Test1.txt (being carefull to
get the case identical) .. and I now have 2 files named
Test1.txt !!!!!

Hmm.....

--

Ah, seems to work after all!

Closing and re-opening the directory did not refresh the
listing.  Once I forced a refresh it works as expected.

Off to code this ...

Thanks Ralf

Did you consider running this from a database. If hosting
allows, you can also use dbisam on server,
and update from local to remove using C/S with Internet
type connection (compressed). The web page could be made
with php using odbc connection to dbisam.
If dbisam is not an option of shared hosting server,
you could synchronize with mySQL server (either directly if
possible or using php script also) and access mySQL
from php even easier.

Just my 2c.

Regards,
Michael

Malcolm wrote:
> This is off topic .. but I know you lot are always keen to
> help!  
>
> I maintain a freeware app (using DBISAM) which updates a
> webpage every 30 secs or so as each (sports) competitor
> performs.
>
> The app builds the html page which is approx 2-3k then FTPs
> it to replace the previous one.
>
> On broadband it runs well .. but some venues only have
> dialup or a weak G3 signal so it can take several seconds
> to upload and this is the problem.    If a surfer's
> browser refreshes during the upload .. blooey, they get a
> blank page and assume the service has failed (when all they
> need to do is Refresh).
>
> So I am looking for advice/pointers/references for a means
> of minimising or eliminating this 'blooey window'.
>
> The web server is Apache 1.3x so an ISAPI.dll is not a
> solution (as far as I know).  Freeware app, so low cost
> solutions are preferred - my time is free!  D6SP2. DBISAM
> 4.22
>
> Any pointers?
>
> (I am a little surprised that FTP servers appear not to
> cache uploads then apply them server-side upon completion
> .... or have I missed something?)
>
> Malcolm

Hi Michael

Yes I have thought about using a database.  It would
probably have to be MySQL which is enabled but unused on my
account.

Certainly I could do a PHP script to query the database and
present the result but for the moment I don't know how to
insert a data row into MySQL from my app.

I do suspect I will need to move to using a database for
some other features my users are starting to ask for.

Where do I look for info on how to upload and insert rows
into a MySQL (or any other) server-side database from my
app?

Malcolm

"Malcolm" <malcolm@spam.will.bounce> wrote in message
news:26DAD198-A14D-44A2-8634-DC230CC23F70@news.elevatesoft.com...
> Where do I look for info on how to upload and insert rows
> into a MySQL (or any other) server-side database from my
> app?

I've never used MySQL, but here are a bunch of Delphi components:

http://delphi.about.com/cs/toppicks/tp/aatpmysql.htm

-Johnnie

Thanks Johnnie, having a look.  

--

There are two ways:
1. Connect to mySQL remotely, using Delphi components
(I believe there's a number of free ones, including AnyDAC).
This, however, is only possible if your provider allow
remote access (very few do). Usually, mySQL is setup to
be only accessible from localhost on server.

2. (I would) Create a simple php script, which posts data
from form's fields into the database and then using any
Delphi component (Indy) to post a web form directly
from your application. The result you receive will indicate
whether the transaction is a success. This is a simple
way of modeling Web Services. I'm not really familiar with
php, but I know how this can be done in jsp. And posting
a form from Delphi is just a matter of simple R&D (Indy's
docs & demos)

Sincerely,
Michael


Malcolm wrote:
> Hi Michael
>
> Yes I have thought about using a database.  It would
> probably have to be MySQL which is enabled but unused on my
> account.
>
> Certainly I could do a PHP script to query the database and
> present the result but for the moment I don't know how to
> insert a data row into MySQL from my app.
>
> I do suspect I will need to move to using a database for
> some other features my users are starting to ask for.
>
> Where do I look for info on how to upload and insert rows
> into a MySQL (or any other) server-side database from my
> app?
>
> Malcolm
>

Thanks for those pointers, Michael

I see some studying coming up.  

--