Query Of Queries runtime error.

[Jancouver]

Query Of Queries runtime error.

Table named users was not found in memory. The name is misspelled or the table is not defined.

======================================================

Just got the error above after I connected the website to a new MySQL server. The connection is verified in Admin but I'm unable to get the database connection working. The query is working just fine with a connection to our old SQL server and it works in MySQL WorkBench.

even simple query like this

<cfquery name="GetUser" datasource="#datasource#" dbtype="#dbtype#" username="#username#" password="#password#">

SELECT    *

FROM      users

</cfquery>

Any ideas?

[cherdt]

You specified both a datasource and a dbtype. In this case, since you are querying a database (and not running a query-of-queries), you should leave out the dbtype attribute. See the cfquery documentation for details.