You were on the right track, Matt. It was one of those smart quotes - a curly apostrophe, as a result of a paste from word. I deleted that character and replaced it with a ASCII one and the XML validated. Also i used the suggestion Terry gave me - replace chr(25) with nothing and that did worked on another record that was giving the same error.
Now to figure out what to do about the 200 fields on several hundred thousand records, now I know what's causing it to break. I am hoping i am going to be able to think of a way to loop through them all instead of spending the rest of the day typing out a replace function in each field. (sigh). Story of my life with this project! Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Jul 4, 2008 at 5:53 PM, Matt Quackenbush <[EMAIL PROTECTED]> wrote: > Probably a result of a copy/paste from Word. Look for ' - ' (a space, a > dash, a space) within that block. Word creates some stupid-ass "smart > character" when that is typed in. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308585 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
