How to update a DB-Field to null ?

Update a database field to NULL using ChronoForms.

Overview

The issue occurs when trying to set a field value to NULL in a Database SaveData action, as the correct syntax for the value in the DataSource is not immediately obvious.
Use the value {const:null} in the DataSource field for the action. This method is confirmed to work in both CF v8 and v7.012.

Ed Eddi Bournell 08 Apr, 2024

In a Database SaveData-action I want to update a field with NULL. Which value do have to choose for the Value in the DataSource?

Max_admin 13 Apr, 2024

Answer

1 Likes

in v8:

{const:null}

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

Ed Eddi Bournell 15 Apr, 2024

1 Likes

surprisingly it works in V7.012 as well! Thanks

This topic is locked and no more replies can be posted.