Connecting to MySQL table

Discussion in 'Cold Fusion MX' started by Rossv1, Mar 9, 2009.

  1. Rossv1

    Rossv1 Perch

    Sorry for the cross-post, but I'm really stumped here...:

    I've got a MySQL database created, CF DSN set up, etc. 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/test.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....

    PS - This works locally!
  2. Stephen

    Stephen US Operations Staff Member

    I just saw this here among the spamdump that hits the forum (so we made only it moderated as 99% of spam was coming here)

    I approved the thread now but think it was resolved on the other, case sensitive linux servers being the cause.
  3. Rossv1

    Rossv1 Perch

    Correct. My local windows machine had tables named mySampleTable, while the remote (Jodohost/linux mysql server) was mysampletable.

    Thanks Stephen

Share This Page

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