Re: [Reactor for CF] Reactor and CF Functions

[Doug Sims]

Is DATEPART("YYYY", timestamp) the name of the database field? I am not at my dev machine to check but I think isEqual() takes 3 params, object, field and value. It looks like you are trying to check to see if  a field named something like '2006' in the ARCommunity table equals the value of #attributes.reportYear#.

If this is what you are trying to do I would try something like this to set the fieldname to use

<cfset fieldname = DATEPART("YYYY", timestamp)>
<cfset reportQuery.getWhere().isEqual("ARCommunity",fieldname, "#attributes.reportYear#") />

Keep on reactor-ing.....
Doug S.

On 6/9/06, Ray Buechler < [EMAIL PROTECTED]> wrote:

Daryl,

That won't work because reactor is looking for that as the database fieldname. ColdFusion thinks it is an undefined variable. I've come to the conclusion that I am trying to do something that is not possible to do. I was trying to use it as I would the SQL function rather than a CF function.

Thanks for the help though!

Ray

On 6/9/06, Daryl <[EMAIL PROTECTED]> wrote:

Add pound signs? e.g.,

<cfset reportQuery.getWhere().isEqual("ARCommunity",
"#DATEPART("YYYY", timestamp)#", "#attributes.reportYear#") />


-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --