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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Reply via email to