Less forgiving perhaps, or it could be that it just does a lot less and thus has less reserved words. Don't get me wrong, I like MySQL and use it myself for some projects, but it is nowhere near as feature rich (yet) as SQL Server (or Oracle or ...).
--- Ben -----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 9:37 AM To: CF-Talk Subject: RE: Moving from MySQL to MS SQL Server 2000 OK...It seems MySQL is more forgiving. Thanks On Wed, 13 Aug 2003 14:28:13 +0100, Craig Dudley wrote: > A fair amount of people simply start table names with 'tbl', which > would solve your problems. > > -----Original Message----- > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] > Sent: 13 August 2003 14:28 > To: CF-Talk > Subject: RE: Moving from MySQL to MS SQL Server 2000 > > > Login is a reserved word. Change the login table name to something > else and it will work. Try not to use names for anything that are > simple names, such as login, password, name, position, etc. > > -----Original Message----- > From: Bushy [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 13, 2003 9:27 AM > To: CF-Talk > Subject: RE: Moving from MySQL to MS SQL Server 2000 > > > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
