SQL insert of unfilled fields

Wappler General Need Help
1

Hello All,

Wappler seems to be generating sql inserts with empty strings (’’) for unfilled numeric forms input fields instead of the NULL value.
This generates a conflict with mysql for numeric columns and causes an error - 1366 Incorrect decimal value – when executing insert statements.
Does anybody know a way to overcome this problem?
Thanks a lot for any help

2

When you submit a form, the empty inputs will always insert an empty string ''

If you want to insert null values, use the default formatter:

{{$_POST.your_input.default(null)}}
1 Like
3

It worked.
Thanks again, Teodor.
Needless to say the Wappler support is outstanding.
Regards.

2 Likes