Hi,
Interesting.
> Thanks for all those who helped me with this a few days ago (I've only now
> had the chance to get back to programming).
>
> As someone correctly surmised, I am using Delphi and connecting to mySQL
via
> a TQuery (actually a TZQuery, via Zeos components). What I have discovere
Thanks for all those who helped me with this a few days ago (I've only now
had the chance to get back to programming).
As someone correctly surmised, I am using Delphi and connecting to mySQL via
a TQuery (actually a TZQuery, via Zeos components). What I have discovered
is that
1. mySQL doesn't li
[snip]
I started with "between", but when this didn't work, I switched to the
comparison operators.
mysql> select projects.name from projects
-> where projects.closeddate between :fd and :td;
ERROR 1064: You have an error in your SQL syntax near ':fd and :td' at
line
2
[/snip]
What are those
2
mysql>
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 4:04 PM
To: Noamn; [EMAIL PROTECTED]
Subject: RE: Comparing date fields
[snip]
I'm in the process of converting an application from Paradox to mySQL
which
is why I have these
[snip]
I'm in the process of converting an application from Paradox to mySQL
which
is why I have these syntax questions.
mySQL doesn't like a query with this syntax:
select p.name,
from projects p, ...
where p.closeddate >= :fd
and p.closeddate <= :td
...
where fd ("from date") and td ("til