Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. eddiebt

    correct mySQL syntax?

    Alternatively Mark, you can replace your query on the date with: SELECT Count(PageUrl) AS PageCount, PageUrl AS URL FROM tbltracker WHERE HitDateTime BETWEEN '2001-01-01' AND '2001-01-06'AND id='biz' GROUP BY PageUrl ORDER BY Count(PageUrl) DESC MySQL date format is yyyy-mm-dd I'm assuming...
  2. eddiebt

    Win32 MyODBC Problem

    Have you entered the port number into your ODBC setup? usually this is 3306
  3. eddiebt

    correct mySQL syntax?

    You can try replacing # with '. If I'm not mistaken the # delimiter is used in Access databases only.
  4. eddiebt

    connecting to mySQL from ASP application

    Alternatively you can go to http://www.mysql.com/downloads/api-myodbc.html and download the ODBC driver for your particular platform.
  5. eddiebt

    INNER JOINs in SQL

    query = "SELECT * FROM cal_events AS E INNER JOIN cal_dates AS D" _ & " ON (E.event_id = D.event_id) " _ & " WHERE event_date BETWEEN " _ & ' 2001-03-01 ' _ & " AND " ' 2001-03-31 ' This is an example that works. You may need to check your version of...
  6. eddiebt

    MYSQL Connection String

    Use this if pointing to an ODBC.ini file (you would need to set these values in the ODBC.ini file on your web server along with port address usually 3306) - assumes ODBC MySQL driver is installed. conn = "DSN=[database name]; UID=[userid]; PWD=[password]; SERVER=[MySQL server IP address]...

Part and Inventory Search

Back
Top