On 4/25/06, Doug Hughes <[EMAIL PROTECTED]> wrote:
> <!--- we want where 1 and where 2 to be true -->
> <cfset where.andWhere(where1, where2) />
This is a very strange method... why does it take two where clauses
rather than just adding to the current where clause?
If it took just one where clause to add, you could do this:
<cfset query = createQuery() />
<cfset where = query.getWhere()
.andWhere(createQuery().getWhere().setMode("or")
.isLike("object","fieldA","xxx")
.isLike("object","fieldB","xxx")
.isLike("object","fieldC","xxx"))
.isEqual("object", "regionId", "yyy")
.isEqual("object", " filetype", "zzz") />
<!--- we've configured the oo query, run it --->
<cfset results = getByQuery(query) />
--
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/
