The only thing I had to do was change the double quotes to single quotes. As for the error, could you post the query so we can see what's going on?
Mark -----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 7:21 AM To: CF-Talk Subject: re: Moving from MySQL to MS SQL Server 2000 Hi, I've just migrated my databases over to SQL server. DO I need to change any of my CF code especially my <cfquery> tags? I get this error when running my app. ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'login'. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
