Found an odd problem when writing an interface where we use a 3rd Party application. The application requires an XML document that it moves from one server to another. We use "for xml auto" to get the XML message.
It turns out if any of the field names have the string "_x" in them they will be changed. So say the field name is "system_xbox_type". This will be changed in the XML to "system_x005F_xbox_type" so when it's read on the other side the "system_xbox_type" is not an element in the XML.
To get around this we just change the name of the field just in the XML, so we converted "system_xbox_type" to "system_type" and then read "system_type" on the other side.
No comments:
Post a Comment