2 Replies Latest reply on Sep 14, 2006 9:57 AM by BrainSan

    Excel and columnnames


      I've been trying to set vars from the result list of an excelsheet.
      After making an ODBC connection for the excelsheet and querying the sheet, everything seems fine.
      The problem is that some columnnames have dots (.) in it, which CF changes it to number signs (#)
      My code is trying to set the result in a struct, but I cannot escape the number signs.

      Example: <cfset somevar = somecolumnnamewith## />

      I've used double number signs and all kinds of escaping techniques, but all in vain.
      Does anyone know what the problem is and have a solution for it?