SELECT user value for null

Bishu · Post by **Bishu** » Mon Feb 20, 2017 12:39 pm

In a field I am using a SELECT with the User Value.
The Field content the NULL, 0, 1 and I want the User Value as
NULL = --
0 = A
1 = P

The user value of 0 and 1 is showing but For the NULL value is not showing.
I try using -
null, NULL, '', "", ' ', " "
But unable to get the User Value of NULL.

mobhar · Post by **mobhar** » Mon Feb 20, 2017 2:09 pm

What is the Field type for that user value in your Database?

Bishu · Post by **Bishu** » Mon Feb 20, 2017 2:11 pm

Field type in INT

mobhar · Post by **mobhar** » Mon Feb 20, 2017 2:30 pm

It should work, as I've just tried it in here, and the NULL option is shown up properly.

Make sure you have already regenerated ALL the script files.