I have a column in SQL Server 2005 that stores a simple chunk of XML. At a later point processing is performed and I need to merge some processing info into the XML. While I can do this at an intermediate point I would much prefer to keep this method centraliazed within the stored procedure that is responsible for updating other fields...
i have never used JSON and want to find more about it as people keep referring to it as a better version of XML for sending data from client to server. can someone please suggest a good resource ...
Hi guys, I'm tasked to design a new API for our infrastructure. Some of the things I'd like to do is: implement oauth for authentication good xml-based structure, adapting ATOM, GEO-RSS and other xml schema standards where applicable. JSON output Some of the things I've been thinking about is applying REST. In practice I find it's n...
I want to allow users to upload files with transaction information to my application. I want users to be able to user their own file format when doing so (XML or CSV). So I'm going to need a transformation from their format to my format before doing further processing. I don't want to have to create this XSLT manually every time a use...
I have a weird requirement where I need to take some xml and re-write it so that the text nodes are wrapped in CDATA (this is for a client that won't allow normal escaping). It doesn't seem like any of the normal XML libraries dom4j, jdom, java xml, have any built in support for this. Any ideas? Can I use XSLT for this? I wasn't very...
I've only recently heard about JSON (Javascript Object Notation). Can anybody explain why it is considered (by some websites/blogs/etc) to be important? We already have XML, why is JSON better (apart from being 'native to Javascript')? Edit: Hmm, the main answer theme seems to be 'it is smaller'. However, the fact that it allows data fe...
We want to use GML in our application; It is a GIS based application which simulates the real word objects (i.e. Pipes, Roads, etc) in a virtual reality environment. Currently we draw and store the geometry in AutoCAD DWGs but in future we want to change the Database. I really need to find the answers of these questions. 1- Is GML prope...
The idea is, upon data entry, automatically export an Oracle Applications (web) form to PDF, storing it in the database. Using XML Publisher, one can allow the user to export it on-demand, but I need to have the report/form PDF generated automatically. Answer A good solution is pretty much covered here. Basically, with a bit of OAF co...
In actionscript 3, when trying to load an XML file like <Element><Property> a </Property></Element> the value in the node "property" will be just "a", trailing and leading whitespaces are removed. I did what http://bugs.adobe.com/jira/browse/ASC-3125 recomends, with no success. Any ideas? ...
I have an XML stored procedure in MS SQL 2005 which I use the SqlCommand.ExecuteXmlReader to get an XmlReader, then parse through the data and form an XML document. The problem is that the data in SQL contains some binary characters which are illegal within a UTF-8 XML document, so an exception is thrown. Has anyone else dealt with this...
Hi all, I'm curious for those of you who are building iPhone apps based on REST/SOAP/XML-RPC or simply pulling down a dynamic XML feed, what does it mean exactly to you when a user says 'refresh' the feed? The straight forward way is to populate some collection, say an NSMutableArray, with whatever you bring down from the feed. If a wi...
I'm trying to serialize an object to XML that has a number of properties, some of which are readonly. public Guid Id { get; private set; } I have marked the class [Serializable] and I have implemented the ISerializable interface. Below is the code I'm using to serialize my object. public void SaveMyObject(MyObject obj) { XmlSeri...
Hi, I have a CSV string that is embedded within an XML document, which is necessary for a flash chart which uses XML. The problem is that the chart gets the settings from the HTML file through a javascript snippet, like so: <script type="text/javascript"> // <![CDATA[ var so = new SWFObject("/gr/amstock.swf", "line", "100%",...
I would like to know how to use the character "
" (LINE FEED) to separate some information in an attribute. Look the example below: <element attrinfo="info1=109
info2=108
info3=107" /> I use SetAttribute() to set the attribute's text, but when the I save the XML, the information in attrinfo looks like that: <element attri...
Greetings all. I'm getting an asp.net error "Root element is missing" when I load the results of a REST request into an XmlDocument. The same REST request looks fine and returns valid results when I execute it using the Firefox addon "RESTTEST". But the error shows up in the C#.net code-behind. Does anyone know what might cause this?...
Hi, I'm trying to get rid of empty namespace tags in my xml file. All of the solutions i've seen are based creating the xml from scratch. I have various xelements constructed from a previous xml. All I'm doing is XElement InputNodes = XElement.Parse(InputXML); m_Command = InputNodes.Element("Command"); and it adding the xmlns = "" ev...
I am trying to create a report in Business Objects using Desktop Intelligence tool (version XI Release 2 on Windows XP). I selected xml data provider and pointed to an xml file. From my Asp.Net web application, I need to bind this report to some xml data which has the same schema. Is there any document or sample .Net source code which c...
I'm using the msxml to parse an xml file. Language is C++. The xml file contains some dates and times using the xsd:dateTime format (Something like that: 2009-04-29T12:00:00Z) Is there an easy way to convert xsd:dateTime to something like SYSTEMTIME, FILETIME or VariantTime? ...
I'm generating regular expressions dynamically by running through some xml structure and building up the statement as I shoot through its node types. I'm using this regular expression as part of a Layout type that I defined. I then parse through a text file that has an Id in the beginning of each line. This id points me to a specific lay...
Hi. I am a total beginner in JS/XML. I have this simple code that needs to be extended to list on the screen attributes and their values for each element of a XML file. function printElement(indent, node) { var i; if (node.nodeType == 3) { document.write("<br />" +indent + node.n...