>
> <cfquery name="weekly" datasource="#application.ds#">
> SELECT testdate
> FROM completedtest
> WHERE EXTRACT(WEEK FROM testdate) = EXTRACT(WEEK FROM
> CURRENT_DATE)
> AND
> EXTRACT(YEAR FROM testdate) = EXTRACT(YEAR FROM
> CURRENT_DATE)
> GROUP BY EXTRACT(DAY FROM testdate)
> </cfquery>
>
> The ERROR is :
> Error Executing Database Query.
> Syntax error or access violation: You have an error in your
> SQL syntax
> near 'WEEK FROM testdate) = EXTRACT(WEEK FROM CURRENT_DATE) AND EX'
> at line 3
I think you would have to take this up with MySQL, since it should
work according to the manual:
http://www.mysql.com/doc/en/Date_and_time_functions.html
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
