Right on. Thanks. It works perfect.
On 2/11/06, Michael Lantz <[EMAIL PROTECTED]> wrote:
>
>
> You would use .isEqual(objectname,fieldname,comparevalue).
>
> So, in your case, after you do the joins below, you would insert something
> like:
>
> <cfset
> local.query.getWhere().isEqual("facilitator","facilitator_id",arguments.event.getvalue('facilitor_id')
> />
>
> That should do it.
>
> Michael
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian
> Billings
> Sent: Saturday, February 11, 2006 3:43 PM
> To: [email protected]
> Subject: Reactor For CF Using "WHERE" in Reactor
>
> All,
>
> This function works properly. How do I say "Where facilitator_id =
> arguments.event.getvalue('facilitator_id')"?
>
>
>
> <cffunction name="ListPrograms" access="public" output="false"
> returntype="ModelGlue.Core.Event">
> <cfargument name="event" type="ModelGlue.Core.Event"
> required="true">
> <cfset var local = structnew() />
> <cfset local.ProgramGateway =
> variables.reactor.createGateway("Program") />
> <cfset local.query =
> local.ProgramGateway.createQuery() />
> <cfset local.query.join("program","facilitator") />
> <cfset local.query.join("program","coordinator") />
> <cfset local.programList =
> local.ProgramGateway.getByQuery(local.query) />
> <cfset
> arguments.event.setValue("Programs",local.ProgramList) />
> <cfreturn arguments.event />
> </cffunction>
>
>
>
> -- 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/
-- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at
http://www.mail-archive.com/reactor%40doughughes.net/
