Interesting problem with XML data populating CFGRID

[katzenwelt]

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.

[katzenwelt]

It appears I have found my own solution...........ListChangeDelims and it works great.  It removed

the comma from my text aligning everything correctly.