Occasionally a field is blank but we have to sometimes have to show a default value or a value from another field. SQL gives us a nice tag to use:<\/p>\n
or we can use if\/else logic this during output Notes:<\/strong> Occasionally a field is blank but we have to sometimes have to show a default value or a value from another field. SQL gives us a nice tag to use: isnull(field1, field2) as name or isnull(field1, ‘n\/a’) as name or … Continue reading isnull(field1, field2) as name or isnull(field1, 'n\/a') as name<\/code><\/p>\n
\n<cfoutput>
\n<cfif #trim(field1)# eq ''>n\/a or #field2#<\/cfelse>#field1#<\/cfif>
\n<\/cfoutput><\/code><\/p>\n
\ndata may contain multiple spaces so isNull may fail. try isNull(rtrim(field1), ‘\/na’) or use #trim()# in the cfoutput logic.
\nisNull may have different syntax or may be ifNull in mySQL.
\nisNull can be used in sql statements where, and group by attributes without the “as fieldname” portion.<\/p>\n","protected":false},"excerpt":{"rendered":"