cannot convert the value x to a boolean

2012-04-30 Thread Tom Small
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

Re: cannot convert the value x to a boolean

2012-04-30 Thread Raymond Camden
, 2012 at 6:27 AM, Tom Small t...@re-base.net wrote: 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

Re: cannot convert the value x to a boolean

2012-04-30 Thread Tom Small
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. Hi Ray thanks

Re: cannot convert the value x to a boolean

2012-04-30 Thread Raymond Camden
You can check to see if a value can be treated as a boolean by checking isBoolean(). On Mon, Apr 30, 2012 at 6:46 AM, Tom Small t...@re-base.net wrote: 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

Re: cannot convert the value x to a boolean

2012-04-30 Thread Tom Small
You can check to see if a value can be treated as a boolean by checking isBoolean(). Hi Ray thanks ~| Order the Adobe Coldfusion Anthology now!