3 Replies Latest reply on Apr 19, 2013 9:32 AM by ColdFusion

    SQL Query on an XMLObject CaseSensitive Resultset

    ColdFusion Level 1

      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