Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
cannot convert the value "x" to a boolean
Author: Tom Small
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63882#350885
>You can check to see if a value can be treated as a boolean by
>checking isBoolean().
>
>
>>
Hi Ray
thanks
Author: Raymond Camden
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63882#350884
You can check to see if a value can be treated as a boolean by
checking isBoolean().
----- Excess quoted text cut - see Original Post for more -----
Author: Tom Small
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63882#350883
----- Excess quoted text cut - see Original Post for more -----
Hi Ray thanks for the reply.
Can you tell me how I should treat the boolean, and do I need to place the
boolean within an cfif statement?
Appreciate your advice.
Tom
Author: Raymond Camden
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63882#350882
I see two issues. First, you are trying arguments.query like a list,
but you don't use the value. Ie, you said, loop over it and put the
value in "keyword", but your code never uses it.
Secondly - you seem to be wanting to treat the keywords as booleans.
That's not going to work.
----- Excess quoted text cut - see Original Post for more -----
Author: Tom Small
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:63882#350881
Hi, I have a loop that searches for keywords, although when I search for 'string'
values get an error: cannot convert the value "x" to a boolean.
If I remove the statement: u.isactive = <cfqueryparam
value="#IIF(arguments.query, 1, 0)#"> then only finds 'string' keywords with
no errors.
If I run the code below it only finds 'boolean' keywords and when I enter a
'string' value produces the error above.
This is a snippet of my code:
<cfloop list="#arguments.query#" index="keyword" delimiters=" ,;">
WHERE u.email LIKE <cfqueryparam value="%#arguments.query#%"> OR
r.rolename LIKE <cfqueryparam value="%#arguments.query#%"> OR
u.isactive = <cfqueryparam value="#IIF(arguments.query, 1, 0)#">
</cfloop>
Thanks
Tom
|
June 20, 2013
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
