> I get this error
>
> Syntax error or access violation: You have an error in your SQL
> syntax near 'WEEK FROM datefld) = EXTRACT(WEEK FROM CURRENT_DATE)
> AND EXT' at line 3
> <cfquery name="weekly" datasource="#application.ds#">
> SELECT date as datefld
Date is a reserved word. Change it while you still can.
> FROM completedtest
> WHERE EXTRACT(WEEK FROM datefld) = EXTRACT(WEEK FROM
> CURRENT_DATE)
I don't think you can use a column alias in the WHERE.
> AND
> EXTRACT(YEAR FROM datefld) = EXTRACT(YEAR FROM
> CURRENT_DATE)
> GROUP BY EXTRACT(DAY FROM datefld)
> </cfquery>
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
