It's a simple query. <cfquery name="checkpass" datasource="databasename"> select * from login </cfquery>
I've added the database via Data Sources (ODBC) under the System DSN tab using the SQL Server driver. I did a test and it passed. On Wed, 13 Aug 2003 09:03:55 -0400, Mark Stewart wrote: > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
