Thanks for your help Rob. I just don't know which field is the culprit as far as the null character (there's no description field or anything obvious like that), and I'm hesitant to CDATA every single field that's going into the db, unless I've exhausted every possible other option.
I'll keep grinding on trying to regex the null character out of there and let the list know if I figure anything out. -- Josh ----- Original Message ----- From: "Rob Wilkerson" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, November 07, 2006 9:25 AM Subject: Re: Cleaning XML - Unicode 0x0 > On 11/7/06, Josh Nathanson <[EMAIL PROTECTED]> wrote: >> Yup, that's the first thing I tried...when it didn't work I posted here >> hoping for further guidance. > > Is the null character in your data or in the XML itself somehow? If > the former, then I think CDATA may be the way to go. It's a good idea > to go there anyway if you're not validating the nature of any variable > data that's being stored. If you're storing prices, for example, then > you're probably okay. If you're storing descriptions, though, which > people may copy/paste from MSWord then including it can be dangerous > if it's not contained in a CDATA block. > > Without a better idea of what your XML structure/content looks like, > that's probably about as much help as I'll be able to provide. Sorry. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
