search

coral-erm / coral

CORAL ERM main repository
http://coral-erm.org/
Other
52 stars 64 forks source link

Protect against non-numeric taxRate value #764

Closed spaceisntsyntax closed 5 months ago

spaceisntsyntax commented 5 months ago

Newer MySQL/MariaDB versions are more strict about type restrictions, and do not like to coerce an empty string to NULL on a numeric column type. Here we make sure that non-numeric user input is dropped, and NULL is stored when a number isn't passed to the input form.