Code Forums - View Single Post

awieds · 04-03-2005, 01:45 AM

Ok, I got it to work. When I did a simple query the connection works and everything is fine. However I ran the following query:
"SELECT ContentsOfBox.*, ProductDescription.*, ProductFeatures.*, Title.*, Products.ProductID FROM (((Products INNER JOIN ContentsOfBox ON Products.ProductID = ContentsOfBox.ProductID) INNER JOIN ProductDescription ON Products.ProductID = ProductDescription.ProductID) INNER JOIN ProductFeatures ON Products.ProductID = ProductFeatures.ProductID) INNER JOIN Title ON Products.ProductID = Title.ProductID WHERE (((Products.ProductID)=1))"

When I run the query is Access it is fine. However when I run it from my asp code my recordset is empty.
ANy suggestions?
Thanks

04-03-2005, 01:45 AM	#3 (permalink)
awieds Registered User Join Date: Mar 2005 Posts: 42	Ok, I got it to work. When I did a simple query the connection works and everything is fine. However I ran the following query: "SELECT ContentsOfBox., ProductDescription., ProductFeatures., Title., Products.ProductID FROM (((Products INNER JOIN ContentsOfBox ON Products.ProductID = ContentsOfBox.ProductID) INNER JOIN ProductDescription ON Products.ProductID = ProductDescription.ProductID) INNER JOIN ProductFeatures ON Products.ProductID = ProductFeatures.ProductID) INNER JOIN Title ON Products.ProductID = Title.ProductID WHERE (((Products.ProductID)=1))" When I run the query is Access it is fine. However when I run it from my asp code my recordset is empty. ANy suggestions? Thanks