More on using a view in a CFWheels model

I have been pulling my hair out (of which I do not have a lot), to try to figure out why I was getting an "Element I.VALUE is undefined in LOC." error when trying to return data with the findall method on a model that used a view when I was passing in a where clause.

Of course, I assumed it had something to do with being a view. After tracing the error down to a single line in the /wheels/model/crud.cfm addWhereClauseParameters method, I figured it was time to post a question to the forum.

Then I took one more look at my where clause. I found at first that if I only had one expression, everything worked fine, so I thought it had something to do with multiple expressions. Then I noticed I had two spaces before one of the AND's (which must be capitalized, by the way). I removed that space, and it worked.

Then I tried to use a small method to create the where clause (it is complicated and I had created it by hand at first to test). But I started getting the same error.

Then I saw that my method placed a space at the end of the where clause. I modified the method to remove this space, and it worked again.