I want to migrate an Adobe Coldfusion app to Lucee and I’m testing the version 126.96.36.199-RC. With the Null Support - Partial Support (CFML Default) setting, my queries return an empty string for the column with a null value. That’s fine. For some reasons I want to use the Null Support - Complete Support, but my queries return null for the column with a null value. My code look like this :
<cfparam name="FORM.myField" default="#myQuery.myNullColumn#" type="string">
It throw this error : The required parameter [FORM.myField] was not provided.
I noticed we can do this:
<cfset FORM.myField = nullValue()>
But not this :
<cfparam name="FORM.myField" default="#NullValue()#">
Is it a normal behavior? If I want to use the Null Support - Complete Support, do I need to rewrite all my code that can return a null value and set a form field with the default attribute?
Is it possible to configure Lucee so that SQL queries return empty fields rather than null like before, but still have full support for null?