NOW() and CURDATE() in Where clause

NOW() and CURDATE() in Where clause

Postby 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
philhuang
 
Posts: 2
Joined: Wed 09 May 2007 20:46

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby philhuang » Thu 10 May 2007 22:32

I believe it is 3.55.20.0 according Corelab.MySql

Thanks
philhuang
 
Posts: 2
Joined: Wed 09 May 2007 20:46

Postby Alexey » Fri 11 May 2007 06:42

Tested this with MySQLDirect .NET 3.55.23. Still no error. Try to use the latest version.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL