I'm searching a MySQL database using ColdFusion that has some empty fields within the database table. These empty fields display in an HTML table on the results page, as just being empty. What I'd like to do is to have the word "none" display if there is no value in the database for that field or column. In other words, I'd like to code my page to have the word "none" appear in place of those empty returns within my table.
Here is the search:
Enter this model number: ET0444-O
Notice that the column for "Model Finish" is empty.
I'd like to have "none" appear in that column.
I tried cfparam with default as "none" but that didn't work.
Could someone please help me?
Thank you in advance.
<cfif NOT Len(Trim(myqueryname.model
<cfset myqueryname.model_finish = "none">