I think I figured it out. I have a web farm and the database name was not specified on one of the server's CF Admin.
thx >From: "S R" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: sql error >Date: Wed, 15 May 2002 15:24:56 -0700 > >That's why this is driving me crazy because I already checked out that >possibility and I'm definitely referencing the correct database. There is a >products table. > >The strange thing is that sometimes it does work and sometimes it doesnt. >It >just doesn't make sense. > > > >From: "Matthew Walker" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: RE: sql error > >Date: Thu, 16 May 2002 10:18:41 +1200 > > > >Um, wild guess . . . no Products table? Are you referencing the wrong > >database? > > > > > >Regards, > >Matthew Walker > >/* > > Cabbage Tree Creative Ltd > > Christchurch - New Zealand > > > > http://www.matthewwalker.net.nz/ > > http://www.cabbagetree.co.nz/ > >*/ > > > > > > > -----Original Message----- > > > From: S R [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, 16 May 2002 10:13 a.m. > > > To: CF-Talk > > > Subject: sql error > > > > > > > > > This one is driving me nuts. I keep getting a 'Base table not > > > found error'. > > > Invalid object name 'Products'. > > > > > > This is my query: > > > > > > SELECT Industries.name as industryName, > > > Products.name as productName, > > > Products.version, Products.prefix, Products.ID as prodID > > > FROM Products, Industries > > > WHERE Products.name = '#COOKIE.prodName#' AND > > > Products.version = > > > '#COOKIE.prodVersion#' AND Products.industryID = Industries.ID > > > order by Industries.name, Products.name > > > > > > Does anyone know what may be causing this if you look at my code? > > > > > > thanks > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
