Re: The joy of FORTRAN

On 04/03/2025 12:25, Niklas Karlsson wrote:

On 2025-03-04, The Natural Philosopher <tnp@invalid.invalid> wrote:

On 04/03/2025 06:25, rbowman wrote:

On Mon, 3 Mar 2025 23:02:44 -0500, c186282 wrote:
>

     It's easy to kinda drift into that during development, you always
     think of ONE more thing you need to pass. However stage two, you put
     all that crap in a struct and pass one pointer. Each function can
     extract what it needs from that struct and ignore the rest.

>
I never made it to anywhere close to 60 parameters. We did have one
utility that took 22 command line parameters but it was never meant to be
invoked manually and came with a csh. Even then they all were stuffed into
a struct before the real function was called.
>
Even worse, the parameters were field widths in a positional record. I
truly hate positional records but the damn things live on.

len=sprintf(query,"insert into day set
timestamp='%s',demand='%f',frequency='%f',coal='%f',nuclear='%f',ccgt='%f',ocgt='%f',french_ict='%f',
irish_ict='%f', dutch_ict='%f', ew_ict= '%f',
pumped='%f',hydro='%f',wind='%f',oil='%f',other='%f', north_south='%f',
scotland_england='%f', solar='%f', biomass='%f', nemo='%f',ifa2='%f',
nsl='%f', intelec_ict='%f',vkl_ict=%f",
timestr,total,frequency,coal,
nuclear,ccgt,ocgt,france,ireland,holland,ew,pumped,hydro,wind,oil,other,north_south,scotland_england,
solar, biomass,nemo,ifa2,nsl,intelec,vkl );

 Not a terribly safe way to build a query. Any database API worth its
salt should have a way to build one with placeholders instead, so the
parameters automatically get special characters escaped and are
generally safer from malicious data.
 

Silly boy. The data is precisely known, and it is all floating point numbers.
Tell me what 'special characters' you get in a floating point number?
  the database is read only  from the world.
So you are simply trolling

Niklas

--
In theory, there is no difference between theory and practice.
In practice, there is.
-- Yogi Berra