Heyyyy.... thanks mate! Works a treat.
On 3/17/06, Sean Corfield <[EMAIL PROTECTED]
> wrote:
On 3/16/06, Jeff Lester <[EMAIL PROTECTED] > wrote:
> 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>.
getWhere().isEqual(...).setMode("or").isNull(...)
Each call appends the condition. By default, where clauses use "and"
unless you set the mode to "or". The mode is active for any added
clauses until you change it.
--
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 -- [email protected]
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
