Page 1 of 1
SQL Dayfile table
Posted: Fri 16 Oct 2015 4:00 pm
by kocher
Currently the Dayfile table is updated at the end of each day.
How can you get to the table Dayfile actualize every 5 minutes?
Re: SQL Dayfile table
Posted: Fri 16 Oct 2015 4:16 pm
by steve
Can I ask why you want to do that? Dayfile.txt is only updated once a day (it contains daily summaries), so updating the corresponding SQL table every 5 minutes would result in 288 copies of the same data.
Re: SQL Dayfile table
Posted: Fri 16 Oct 2015 4:25 pm
by kocher
Thanks for your quick reply Steve.
I have explained wrong
I would like the last record (only 1 record) corresponds to the current day updated (overwrite) every 5 minutes
Re: SQL Dayfile table
Posted: Fri 16 Oct 2015 4:31 pm
by steve
The last record is for
yesterday. It doesn't change once written.
If you want a table with
today's highs and lows
so far, you could create a custom table and use
today's web tags to populate it with data.
Re: SQL Dayfile table
Posted: Fri 16 Oct 2015 4:41 pm
by kocher
OK
Thank you very much Steve
Re: SQL Dayfile table
Posted: Fri 16 Oct 2015 7:15 pm
by sfws
You could write a php script using an appropriate combination of SQL calculations on dayfile columns and/or calculation using today web tags. So that is a variation on Steve's suggestion.
Re: SQL Dayfile table
Posted: Fri 16 Oct 2015 8:37 pm
by kocher
Greetings sfws
Is it possible to know your script?
