NULLs are actually NULL now (what a concept, right?).
If possible, I'd filter the nulls out on the main (real) query... if not,
I'd probably use this instead:
AND (order is NULL or order = '')
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original
>>Any ideas why the original where clause stopped working? I thought CF
>>treated all NULL value fields in a record set as an empty string.
probably the CF9 code is more consistent with SQL.
Right, if a field is returned NULL in a query, CF treats it as an empty string,
but apparently, the N
2 matches
Mail list logo