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
