lundi 29 juin 2015

Statement Passed to Mysql Database not filling DataTable

 dbQuery = "SELECT * FROM table WHERE date BETWEEN " & startDate & " AND " & endDate & ""

When i execute this statement in NaviCat it does not return any values either. Tho the values do exist on the 19th and 22nd of June in 2015. am i sending the query wrong???

Upon debugging the query is sent as follows.

select * from table where date between 6/1/2015 and 6/31/2015

Aucun commentaire :

Enregistrer un commentaire