1 Reply Latest reply on Jan 14, 2010 4:14 AM by katzenwelt

    Interesting problem with XML data populating CFGRID


      Greetings all,

      I ran into an issue yesterday and I'm not sure how to resolve it.  I have an XML file I load to my MSSQL 2005 database, from there I populate my CFGRID with the fields from the database table, pretty straightforward right?


      It is until I realized the customer name appears to have a comma, so it looks like this:  Smith, John


      It appears Cold Fusion (cfGrid?) is looking at the comma as a delimeter and taking the value after the comma and putting it into the next column, basically shoving everything to the right.


      When I view the data in MSSQL Management Studio, it displays fine.  Does CF get the recordset from the database as a comma delimeted list?  Is this a known bug within CF?


      I need to fix it obviously but I'm not sure if it's easier to do it from within CF or when I load the XML file into the database.


      Any thoughts or guidance would be appreciated.