Question
Searching on a field
This one is baffling me to no end. I have a store with a db
of products and descriptions. So of course I want the visitor to be
able to search the db for what they want.
When I test the query in the query builder in access it works fine. Does what it is supposed to do. Then I move it to ColdFusion and it only returns values where the search word is the first word in the description field.
SELECT productid, productname
FROM products
WHERE productdescription LIKE '%#searchword#%'
GROUP BY productid, productname
ORDER BY productname
Why doesn't this work right in CFQUERY but works fine in Access query builder?
When I test the query in the query builder in access it works fine. Does what it is supposed to do. Then I move it to ColdFusion and it only returns values where the search word is the first word in the description field.
SELECT productid, productname
FROM products
WHERE productdescription LIKE '%#searchword#%'
GROUP BY productid, productname
ORDER BY productname
Why doesn't this work right in CFQUERY but works fine in Access query builder?
AdChoices