-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 9:16 AM
To: CF-Talk
Subject: Re: Query date
Robert Orlini wrote:
> 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]
