I have Complete Support for Null turned on...
I noticed some weird results when I got null values from the db, and wrote this simple test page:
Similar to the sample code in the Lucee docs: https://docs.lucee.org/guides/cookbooks/NullSupport.html
The output says myQuery._null is Empty:null, as expected.
but isNull(myQuery._null) is false
It's possible that this is an old bug, since apparently my version of Lucee is out of date, but I don't currently have the ability to upgrade it myself to test. We're converting a large project from an old version of BlueDragon and this is the version of Lucee we are developing on for the time being. I just figured I'd pass this along in case it's still a problem, and I'd appreciate it if somebody could let me know whether or not it's been fixed in later versions.
Windows Server 2019
MS SQL Server 2017