...

View Full Version : ASP & Access Query



silverskymedia
12-05-2007, 05:43 PM
Hello, I'm not sure this is the right forum. I'm having issues with a query. I'm using ASP (VBScript) and MS Access. The syntax of the query seems to be fine within other syntax validators, but Access doesn't like it. I'm getting an operator error.



SELECT TOP 5 Category.Title, article.pubDate, article.Title AS Title, *
FROM Article
INNER JOIN Article_Category ON Article.ID = Article_Category.ArticleID
INNER JOIN Category ON Article_Category.CategoryID = Category.ID
WHERE Article.ID IN (SELECT Article_Category.ArticleID FROM Article_Category
WHERE Article_Category.CategoryID IN (
SELECT Article_Category.CategoryID
FROM Article_Category
WHERE Article_Category.CategoryID.ArticleID = 5132005));


Thanks.

lyschange
12-10-2007, 08:32 AM
5132005-----make this a string ie '5132005'



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum