Query Works in Access, not through ASP/ADO

[GravyMonster]

WTF??? This has been annoying me for a couple of hours now as there is absolutely no logic behind this.

here's the query...

SELECT Products.ProductID, Products.Name, Products.Description, Products.Cost, Categories.Rank FROM Products INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID WHERE Products.Name LIKE '*gloves*' OR Products.Description LIKE '*gloves*' ORDER BY Categories.Rank;

it works like a charm in Access Query editor, but when i try to use it through ADO, i get 0 rows returned.

Has anyone had this before?

God I wish they'd bought some SQL hosting!

 

[Haircut]

Have you tried replacing the wild card characters (*) with %?

Depending on the driver you're using you may need to use the ANSI SQL wildcard, which is %

 

[GravyMonster]

Yeah, i was originally using the % char, but that wasn't working either.

However, I've found a happy solution - and convinced them that SQL hosting is the way forward, especially for a shop which will eventually contain 150+ items. Hurrah!