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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350881
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
