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
