Connecting to MySQL table

Discussion in 'Database Support' started by Rossv1, Mar 9, 2009.

  1. Rossv1

    Rossv1 Perch

    I've got a MySQL database created. I can successfully connect to it with a simple query to SHOW TABLES;

    When I run this query, I see all of the tables in the database.

    When I try to query a table, I receive an error that the table does not exist (it does).

    I'm connecting via ColdFusion on CF3/MySQL8

    Here you can see a dump of the tables:
    http://ukspirit.cnypcdoc.com/untitled.cfm

    Here you can see where I cannot connect:
    http://ukspirit.cnypcdoc.com/index.cfm

    the query is:

    <cfquery name="eventQuery" datasource="#application.dsn#" >
    SELECT *
    FROM ukEvent
    </cfquery>

    Anyone got any ideas? Why can I not connect to this table??? SHOW TABLES does work, and does show that this table exists....
  2. Rossv1

    Rossv1 Perch

    Solved

    My local database is not case dependent.

    Jodohost MySQL server IS case dependent.
  3. Good Oyster

    Good Oyster Perch

    Are you running your local DB on a Windows machine? JH MySQL servers are running Linux, which is always case sensitive. So your SQL statements need to be case sensitive.

    I've found it best practice just to consider everything case sensitive. That way if you ever move something from a Windows to a Linux environment, you won't get any surprises.
  4. Rossv1

    Rossv1 Perch

    That is exactly the issue. Thanks for the reply.

    For my getting-too-old-for-coding eyes, a table name like this:

    myFirstTable

    is much easier to read :) A habit I need to break, I know!

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services