1 Reply Latest reply on Apr 30, 2008 7:41 AM by Michael Borbor

    CF Query Column Names Returned in UPPERCASE

    ericbelair Level 1
      My Flex application retrieves data from the database using Stored Procedures and Queries in CFCs. However, when I return the query object from the CFC to the Flex application, all of column names in the result set are returned as UPPERCASE.

      For example, if I run the following query:

      SELECT someParam, anotherParam, heyThere
      FROM myTable

      The SOAP Response comes back like this:

      <?xml version="1.0" encoding="utf-8"?><soapenv:Envelope xmlns:soapenv=" http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd=" http://www.w3.org/2001/XMLSchema" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance">
      <soapenv:Body>
      <ns1:someQuery soapenv:encodingStyle=" http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1=" http://cfc.private">
      <someQuery xsi:type="ns2:QueryBean" xmlns:ns2=" http://rpc.xml.coldfusion">
      <columnList soapenc:arrayType="xsd:string[17]" xsi:type="soapenc:Array" xmlns:soapenc=" http://schemas.xmlsoap.org/soap/encoding/">
      <columnList xsi:type="xsd:string">SOMEPARAM</columnList>
      <columnList xsi:type="xsd:string">ANOTHERPARAM</columnList>
      <columnList xsi:type="xsd:string">HEYTHERE</columnList>
      </columnList>
      ....

      Is there any way around this? I would like to get the Column Names returned with the case they are specified in the query, since this conforms to the coding standards I am following. Instead, I have to reference the properies in my resulting ArrayCollection in all CAPS, which I reserve for constants.

      Thanks.