I have a query which works fine in access but I get this message when trying to run it in ASP:- Error Type: Microsoft JET Database Engine (0x80040E14) Join expression not supported.
ACCESS QUERY CODE = SELECT [products].[ProductID], [products].[QuantityperUnit], [products].[UnitPrice], [products].[ProductName], [products].[Discontinued], [categories].[categoryname] FROM categories LEFT JOIN products ON [categories].[categoryid]=[products].[CategoryID] WHERE ((([products].[Discontinued])="0")) ORDER BY [categories].[categoryname]; ASP CODE = strQ= "select Products.ProductID,Products.ProductName," strQ=strQ & "Products.QuantityperUnit,Products.UnitPrice,Products.Discontinued," strQ=strQ & "Categories.CategoryName " strQ=strQ & "FROM Products LEFT JOIN " strQ=strQ & "Categories ON " strQ=strQ & "Products.CategoryID =Categories.categoryid" strQ=strQ & "WHERE (Products.Discontinued =0)" strQ=strQ & "ORDER BY Categories.categoryname" objRS.Open strQ ANY IDEAS??? BEV --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
