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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]