Connecting to MySQL table

R

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!
 
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.
 
Correct. My local windows machine had tables named mySampleTable, while the remote (Jodohost/linux mysql server) was mysampletable.

Thanks Stephen
 
You must log in or register to reply here.
Back
Top