Search results

  1. K

    DateTime Comparing

    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...
  2. K

    SQL Syntax Error

    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?
  3. K

    SQL Syntax Error

    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...
  4. K

    SQL Syntax Error

    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...
Top Bottom