that's not it. That would give you a DATASOURCE NOT FOUND error. Chances
are you just mapped to the wrong DB somewhere or your permissions are
screwed up somehow.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 3:31 PM
To: CF-Talk
Subject: RE: sql error
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
> > >
> > >
> > >
> >
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
