Re: [Reactor For CF] orWhere()

[Jeff Lester]

Good call, thanks. In my application I need to return all records where a column contains either no value, or a specified value. Currently I am using the getWhere().isEqual() on the gateway object to get the records which match the specified column value. But I also need it to get the ones where the column in <NULL>. This is why I was hoping to use the orWhere() function as it states that it can look for two where clauses. I hope this helps explain it a bit further.

On 3/17/06, Sean Corfield <[EMAIL PROTECTED]> wrote:

On 3/16/06, Jeff Lester <[EMAIL PROTECTED]> wrote:
> Sorry about that, had my email set to UTF-8 encoding... weird. Anyhow, I
> need help on an example of using the orWhere() function of the query
> object... can you guide me?

That's a strange method... I don't really understand why it exists (or
andWhere() and negateWhere()) since they behave in a distinctly
non-intuitive manner.

What they do is to append two new where clauses (one in the case of
negateWhere) to an existing where clause.

Perhaps if you explain what you're trying to do, we can suggest how
you might write it with Reactor? That might be more productive than
trying to explain a method you might not even need to use...
--
Sean A Corfield -- http://corfield.org/
Got frameworks?

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood



-- Reactor for ColdFusion Mailing List -- reactor@doughughes.net
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/

-- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/