Cannot convert the value "Not a boolean" to a boolean

Sample code

<cfset notABoolean = "Not a boolean">

<cfif notABoolean>

</cfif>

Explanation

The sample code is attempting to use the string "Not a boolean" in a place that expects something that will evaluate to true of false.

Submitted by Adrian Lynch on Wednesday 12 November 2008

Comments

Posted by Adrian Lynch on Friday 14 November 2008

A common place for this to happen is when you have what you think is number in a query, myQuery.myColumn and you use boolean logic like:

<cfif myQuery.myColumn>

If it returns a null, an empty string when you attempt to use in in such a fashion, the logic will fail.

A way around this is to use:

<cfif Val(myQuery.myColumn)>

Which will replace an empty string with a zero.

Add a comment or subscribe to this error