NOW() and CURDATE() in Where clause

philhuang · Post by **philhuang** » Wed 09 May 2007 21:01

Try to use NOW() and CURDATE in WHERE clause in Query Builder. The task list always show 1 Build Error near NOW() or CURDATE(). However, the query can be run without any error in VB.Net 2003 or MYSQL Query
What is wrong for my query in Query Builder?
Select * from Orders where datediff(NOW(), otime) <= 7

Thanks

Alexey · Post by **Alexey** » Thu 10 May 2007 07:56

Which version of MySQLDirect .NET do you use?
I've just checked this with v4.0 and got no error.

philhuang · Post by **philhuang** » Thu 10 May 2007 22:32

I believe it is 3.55.20.0 according Corelab.MySql

Thanks

Alexey · Post by **Alexey** » Fri 11 May 2007 06:42

Tested this with MySQLDirect .NET 3.55.23. Still no error. Try to use the latest version.