Wappler Version : 2.1.5
Operating System : Windows 10
Steps
Server Action > Database Update (SQL Server, Classic ASP)
Set a numeric value (INT) to NULL
Actual behavior
Sets Value to ‘NULL’
How to reproduce
Server Connect to SQL Database
Server Connect Action Database Update
Update Table Set Field (Which is an INT) = NULL
Can be resolved by manually changing the DMXConnect script and removing the surrounding single quotes
from
"query": "UPDATE Contact\nSET Cont_Status = :P1 /* {{$_POST.StatusDropdown}} */, Cont_Deleted = 'NULL'\nWHERE Cont_ContactId = :P2 /* {{$value}} */",
to
"query": "UPDATE Contact\nSET Cont_Status = :P1 /* {{$_POST.StatusDropdown}} */, Cont_Deleted = NULL\nWHERE Cont_ContactId = :P2 /* {{$value}} */",
Community Page
Last updated:
Last updated: