I make a SQL query on an object with dbtype = query
<cfquery name="qry_catalog" dbtype="query">
SELECT * FROM catalog query
WHERE country LIKE '# art #'
What also goes without problems, interestingly, the query takes only results when the Upper / lower case is correct.
e.g. Search for "UK" brings 13 records from the XML object "uk" no.
I have never read that it is case-sensitive.
I'm open to all suggestions.
Thank you greeting Jochen
if you need a case insensitive query do something like where upper(something) = #ucase(something)#
I believe it's commonly known that it's case sensitive. e.g. it's documented here:
"Unlike the rest of ColdFusion, Query of Queries is case-sensitive. However, Query of Queries supports two string functions, UPPER() and LOWER(), which you can use to achieve case-insensitive matching."
many thanks for the quick response.
I'm still a beginner.
Best regards, Jochen