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