Try removing the quotes around your function call otherwise Reactor sees
the function call as a literal string:
<cfset reportQuery.getWhere().isEqual("ARCommunity", DATEPART(YYYY,
timestamp), "#attributes.reportYear#") />
Mark
Ray Buechler wrote:
This line of code:
<cfset reportQuery.getWhere().isEqual("ARCommunity", "DATEPART(YYYY,
timestamp)", "#attributes.reportYear#") />
Generates the following error:
The field 'DATEPART(YYYY, timestamp)' does not exist for the
'arCommunity' object.
If it is not obvious, I am trying to pull records from a specific year
from a datetime field.
My questions are:
A. Is there a mistake in my code?
B. Am I trying to do something that Reator is not designed to do?
C. Is this a bug in Reactor?
Thanks!
Ray
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
