[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 ("till date") are parameters. Can one use
greater than/less than operators, or is there some other way of
filtering
only those records with closeddates in the range that I specify?
[/snip]
You can use BETWEEN (which is inclusive of the dates specified)
select p.name, ....
from projects p, ...
where p.closeddate BETWEEN date AND date
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
