I think you may be missing some spaces.
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
-----Original Message-----
From: bev [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 6:13 AM
To: ActiveServerPages
Subject: access 2000 + query syntax FOR ASP PAGE
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.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
