Search results for query: *

hey i need to pull out the data from the database by day. In the database the field is a MySQL datetime. I just want to do a count for all records with a sertain day. my code is : Dim bdwsmtCon As New Odbc.OdbcConnection("Driver={MySQL ODBC 3.51...

So that code would work to pull out all date from the database that have the same date as my datetimepicker? Even if there's a time attached to the date in the database?

I tried a bunch of different things to get that sql error to go away and non of them worked. So i re factored my project and made the the sql statement vary simple. Yet i still have one problem. Here's the code Dim bdwsmtCon As New Odbc.OdbcConnection("Driver={MySQL ODBC 3.51...

hello, i am currently writing a program that will requires to read from a mySQL database and write the data to a Excel file. I have the writting to the excel file, but my select statement gives me a sql syntax eror. my code looks like this : Dim strSQL As String 'Select statment Dim...