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 > > > > > > > ______________________________________________________________________ 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 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
