> Thanks Jochem. I still get an error. See below:
>
> Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'FROM'.
>
>
> SQL = "SELECT * FROM maintenance_report WHERE EXTRACT(MONTH FROM maint_report_date) = ? ORDER BY id DESC"
Probably MS SQL Server does not support the SQL standard EXTRACT
function. You should be able to find the equivalent in the
manual, and don't forget to tell MS you want better standard
compliance.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
