It must be picking up the #DSN# variable from somewhere. If you haven't got an application.cfm file in the same folder as the template with the query CF will look further up the tree - all the way to the root folder in fact. Try hardcoding the DSN to see if that fixes it.
-----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Friday, 3 January 2003 8:27 AM To: CF-Talk Subject: Error saying "test.passwords" table not found...That's because there's not one! Hi, all...Happy New Year... I've been working with CF (4.5.2) and MySQL (4.0.7 gamma) for a few weeks on my development box (Win 2000 Pro) and have just setup MySQL and MyODBC on my Win 2000 Server. Everything seemed fine until I tried to login on an app that I built to run on that server. I get the error that [MySQL][ODBC 3.51 Driver][mysqld-4.0.7-gamma-nt] Table 'test.passwords' doesn't exist That's true, there is no table called 'passwords' in the test db (the test db was something installed by PremiumSoft's Navicat or perhaps by MySQL itself). The fact that there is not 'passwords' table in the test db shouldn't matter, because that't not even the datasource that I'm querying with CF..I'm querying 'rchnetwork-mainoffice' db and 'passwords' table is in there. Why would it be trying to look in to the 'test' datasource for the 'passwords' table and not in the 'rchnetwork-mainoffice' datasource during the query? The query has been running fine on my development box... <CFQUERY Name="CheckPassword" Datasource="#DSN#"> Select UserID from Passwords P where P.Password='#Form.Password#' </CFQUERY> Clues? Thanks, Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
