asked on ColdFusion Help displaying default value
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:
http://flashdesyne.com/wilsoncabinetry/search.cfm
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.
elizabeth
Here is the search:
http://flashdesyne.com/wilsoncabinetry/search.cfm
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.
elizabeth
ColdFusion Language
Last Comment
Chris Ashcraft
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
This isn't correct..
<cfif NOT Len(Trim(myqueryname.model
<cfset myqueryname.model_finish = "none">
</cfif>
You cannot assign a value to a query column, although you could use the query set cell function.
<cfparam..> doesn't work because it does not test for empty, it tests for a non-existant variable...
Here's how you can do it..
In your select statement you can do this..
select isNull(model_finihs,'none'
, ...
from table...
Or when displaying you can use a CFIF statement..
<cfif Len(Trim(myqueryname.model
#myqueryname.model_finish#
<cfelse>
none
</cfif>
<cfif NOT Len(Trim(myqueryname.model
<cfset myqueryname.model_finish = "none">
</cfif>
You cannot assign a value to a query column, although you could use the query set cell function.
<cfparam..> doesn't work because it does not test for empty, it tests for a non-existant variable...
Here's how you can do it..
In your select statement you can do this..
select isNull(model_finihs,'none'
, ...
from table...
Or when displaying you can use a CFIF statement..
<cfif Len(Trim(myqueryname.model
#myqueryname.model_finish#
<cfelse>
none
</cfif>
You can do this in one line with IIF...
<cfoutput>
#IIF(LEN(TRIM(myqueryname.model_finish)), DE(myqueryname.model_finish), DE("none"))#
</cfoutput>
btw using IIF will effect Performance of the page, So i will not recommend it
Not really, no... http://www.bennadel.com/blog/162-ColdFusion-IIF-vs-CFIF.htm
<cfif NOT Len(Trim(myqueryname.model
<cfset myqueryname.model_finish = "none">
</cfif>