My "show tables" mistery in linux-mysql-apache environment
Posted on 2003-03-14
I have used the Show tables and show databases
without any problems inside the cfquery tag from
non linux machines, running coldfusion mysql and IIS server.
But I have never seen the same code work in the 2 linux-mysql-apache servers I have tested.
Is there an issue on this. Please help. I have been in search of an answer for this for a long, long time. Why a code like this connecting to a database called MyDB would not work
when I run it in a linux-apache-mysql-coldfusion environment, but it works beautiful in windows-IIS-mysql-coldfusion machine:
<cfquery datasource="MyDB" name="getTables">