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.
It appears I have found my own solution...........ListChangeDelims and it works great. It removed
the comma from my text aligning everything correctly.