I've never actually used this function, but I think you want:
<cfset
query.getWhere().isEqualField("Ministries","ParentID","Ministries","id")/>
You can check the where object in the Reactor files for available methods. This one wants the name/alias of the Table (object), Field, then the Table (object) and Field to make the comparison to. So it should work as a join, too.
--
Thanks,
Tom
Tom McNeer
MediumCool
http://www.mediumcool.com
530 Means St NW, Suite 110
Atlanta, GA 30318
404.589.0560
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
- [Reactor for CF] GetWhere.IsEqual() Question Joshua Scott
- Re: [Reactor for CF] GetWhere.IsEqual() Question Dan Vega
- Re: [Reactor for CF] GetWhere.IsEqual() Question Tom McNeer
- RE: [Reactor for CF] GetWhere.IsEqual() Question Joshua Scott

