Gizmo

Gizmo

  • NA
  • 4
  • 9.2k

Query returns 0 rows..

Apr 6 2006 12:32 AM
Hello My problem is pretty straightforward, the following query returns nothing: oleDbCommand2.CommandText="SELECT Orders.OrderID FROM Orders WHERE Orders.CustomerID='"+cusID+"' AND (Orders.OrderDate BETWEEN "+startDate+" AND "+endDate+")"; However, when I remove the "AND Orders.OrderDate BETWEEN..." part, my query works fine. Any ideas on what could be the problem? And yes, I've checked that the database does contain rows for those dates. Thanks!

Answers (1)