Thread: update table from internet site

update table from internet site

From
Ennio-Sr
Date:
Hi!
I'm thinking about creating a table listing my shares (say 'Shares') and
then update its price column from a .txt file (say 'Prices') downloaded
from an internet site periodically.
Recalling past readings my first idea would be to use
something like:
=> update table Shares set price = (select price from Prices)
   where
   Shares.name = Prices.name;
and, of course, table Prices would be re-construed each time as a
=> copy Prices from raw.dowld.txt
My question is:
. Is there a better way to do that?
. Is it possible to introduce any automation in the process?

Your suggestions (even to docs/how-tos) shall be appreciated.
Regards,
    Ennio.

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.     \\?//
 Fa' qualche cosa di cui non sei capace!"   (diceva Henry Miller) ]     (°|°)
[Why to use Win$ozz (I say) if ... "even a fool can do that.             )=(
 Do something you aren't good at!" (used to say Henry Miller) ]

Re: update table from internet site

From
Mike Nolan
Date:
> I'm thinking about creating a table listing my shares (say 'Shares') and
> then update its price column from a .txt file (say 'Prices') downloaded
> from an internet site periodically.

You'd probably be better off writing a small program in a language like
PHP or perl that reads the text file and updates the table.  That way
the program can deal with bad data and other possible errors.
--
Mike Nolan

Re: update table from internet site

From
Ennio-Sr
Date:
* Mike Nolan <nolan@gw.tssi.com> [250804, 13:23]:
> > I'm thinking about creating a table listing my shares (say 'Shares') and
> > then update its price column from a .txt file (say 'Prices') downloaded
> > from an internet site periodically.
>
> You'd probably be better off writing a small program in a language like
> PHP or perl that reads the text file and updates the table.  That way
> the program can deal with bad data and other possible errors.
> --

Do you mean putting the commands in a script or a more complex program?
[I've no idea about 'programming' in php or perl :-( ]
    Ennio

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.     \\?//
 Fa' qualche cosa di cui non sei capace!"   (diceva Henry Miller) ]     (°|°)
[Why to use Win$ozz (I say) if ... "even a fool can do that.             )=(
 Do something you aren't good at!" (used to say Henry Miller) ]