SQL Query on an XMLObject CaseSensitive Resultset

Forum|Forum|12 years ago
April 19, 2013
2 replies
883 views

Hi there,
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 #'
</ cfquery>

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

This topic has been closed for replies.

D

duncancumming

Participating Frequently

I believe it's commonly known that it's case sensitive. e.g. it's documented here:

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=using_recordsets_7.html

"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."