Thank you Tom.
Adding those backticks did the trick. To make the code future/fool proof
I've added those backticks to all the sql names in case someone runs into
the same issue working with MySQL database..
SELECT `dateTime`, `interval`, `usUnits`, `outTemp`, `extraTemp1` FROM
`archive` WHERE
In MySQL, the word 'interval' is a reserved word, so you need to enclose it
in backticks. The SQL statement should be
"SELECT dateTime, `interval`, usUnits, outTemp, extraTemp1 FROM archive
WHERE dateTime > %(start)s AND dateTime <= %(stop)s;"
One thing to be aware of: values can be None. So
I noticed a weird typo: skin.info should be skin.conf ofcourse.
Op vrijdag 11 september 2020 om 12:50:34 UTC+2 schreef Arend:
> Hello,
>
> Just starting to become familiar with user defined types (XTypes), and
> tried to create a new type called lowTemperature. This type compares the
>