View Single Post
  #5 (permalink)  
Old March 30th, 2005, 04:54 PM
ibi ibi is offline
Registered User
 
Join Date: Mar 2005
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is what I've got now:

SELECT TOP 10 * FROM Product WHERE ((ManufacturerFeaturedOrder) Is Not Null) AND ((ManufacturerID)=" & man & ") AND ((Active)=True) ORDER BY ManufacturerFeaturedOrder;

It works if I use:

SELECT TOP 10 * FROM Product;

i.e without any WHERE clause.

So the problem is not with the database or connection but the query itself??

ibi

Reply With Quote