I just realized the syntax you are using. DATEPART is a SQL function,
correct? I don't think you can pass actual SQL statements into the
Reactor query object to get a different format for an existing field for
comparison. You may just need to create a normal ColdFusion cfquery
statement to handle SQL statements like this.
Mark
Ray Buechler wrote:
Mark,
Should have thought of that although I still get an error:
Variable YYYY is undefined.
So I tried single quotes around timestamp and got the following error:
Parameter validation error for function DATEPART.
The value of the parameter 2, which is currently "timestamp", must be
a class java.util.Date value.
I'm assuming that CF and reactor are seeing that as a literal string
again. If I put single or double quotes around YYYY I get the
"Variable YYYY is undefined." error again.
Anyone have any ideas?
Thanks,
Ray
On 6/9/06, *Mark Mazelin* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
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] <mailto:[email protected]>
> Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
> -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected] <mailto:[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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
