0 Replies Latest reply on May 19, 2014 12:56 PM by ion

    Unable to preserve indentation in cfgrid

    ion Level 1

      I have a cfgrid bound to a query in a cfc. The query indents one of the columns with blank spaces dependent on a hierarchy, like:

       

      ...

      SELECT regularColumn, indentedColumn = replicate(CHAR(32),((Hlevel-1)*2))+' '+indentedColumn

      ...

       

      Query works fine, i can see the indents in SQL server manager, but they never make it back to cfgrid. If i pick any other "visible" character works fine.

       

      Any ideas?

       

      Thanks