xml

TSQL Shred XML - Is this right or is there a better way (newbie @ shredding XML)

Ok, I'm a C# ASP.NET dev following orders: The orders are to take a given dataset, shred the XML and return columns. I've argued that it's easier to do the shredding on the ASP.NET side where we already have access to things like deserializers, etc, and the entire complex of known types, but no, the boss says "shred it on the server, ret...

Ajax message best practices

Say I need to use ajax to asynchronously ask the server for an xml file containing relevant data. What is the best practice on what this message should look like? Should it be a string like get_data or something similar? Should it be xml? I don't really need long polling since its a one-time (or close to it) request. Thanks. ...

TSQL Shred XML - Working with namespaces [ANSWERED]

Here's a link to my previous question on this same block of code with a working shred example Ok, I'm a C# ASP.NET dev following orders: The orders are to take a given dataset, shred the XML and return columns. I've argued that it's easier to do the shredding on the ASP.NET side where we already have access to things like deserializers,...

Problem with parsing XML into table variable

I'm using the following code to read a SQL XML Variable into a table variable. I am getting the following error. " Incorrect syntax near '.'. " Can't quite Figure it out DECLARE @LOBS Table ( LineGUID varchar(40) ) DECLARE @lg xml SET @lg = '<?xml version="1.0" encoding="utf-16" standalone="yes"?> <Table> <LOB> <LineGuid>d6e3a...

Alter a single attribute with XSLT

Hello! <?xml version="1.0" encoding="utf-8" ?> <configuration> <system.web> <compilation debug="true" defaultLanguage="C#"> <!-- this is a comment --> </compilation> </system.web> </configuration> What's the simplest XSLT you can think of to transform the value of the first, in this case only, /configuration/system.w...

XPath to return only elements containing the text, and not it's parents

In this xml, I want to match, the element containing 'match' (random2 element) `<root> <random1> <random2> match </random2> <random3> nomatch </random3> </random1> </root>` ok, so far I have: //[re:test(.,'match','i')] (with re in the proper namespace) this returns random2, random1 and root... I would like to get only "random2" an...

Drupal Views Bonus Pack export issue

Hi, In trying to solve the problem of getting data from Drupal into XML, I found the Views Bonus Pack module, which with a little figuring out works great. Except... When setting the Style property in the Basic settings of Feed view to XML file no items show up unless I am authenticated. If I log in, I see all the entries. If I log ...

Program skips code after trying to parse XML in VB.NET

I'm trying to parse some XML (html) I downloaded using WebRequest.Create() and then read it. However after loading the XML file using LoadXml(string), anything else I execute doesn't work. Setting a breakpoint on anything afterwards doesn't work and it doesn't break. I tried catching exception but none are occurring, so I'm not sure wha...

Dump XML Posts from 'php://input' to file

I'm trying to write a parser for a xml postback listener, but can't seem to get it to dump the xml for a sample. The API support guy told me to use 'DOMDocument', maybe 'SimpleXML'? Anyways here's the code: (thanks!) <?php $xml_document = file_get_contents('php://input'); $doc = new DOMDocument(); $doc->loadXML($xml_document);...

Sum value of XML attributes using PowerShell 2.0

I have a directory with XML files. I quickly want to go through them and sum upp the value stored in one attribute. I have figured out how to fidn the nodes I am interested in. For example: (Select-Xml -Path .\*.xml -XPath "//*[@Attribue = 'valueImlookingfor']").Count This command gives me the count of elements in all of the XML fil...

100k+ Records and sp_xml_preparedocument

I've been encountering a seeming deadlock with one of my tables and the only place I can trace it back to is a stored procedure that uses sp_xml_preparedocument on a list of data. The data inserted, btw, consists of a 100k+ records on average. Is it possible that it is causing the deadlock? What other pitfalls does using sp_xml_preparedo...

Adding namespace definition to xml using apache xmlbeans

I need to add namespace defintion to an element since its not getting added when when xml is generated using apache xmlbean. How do I acheieve this using xmlbeans API? ...

Documentation with NDOC3

I am working on a project documentation using NDOC3. The build fails when trying to document 3rd party DLLs (because I do not have the xml documentation for them). How could I address this issue ? ...

how do read the child node from xml file

how do read the child node from xml file ...

XML + DOM + need to remove specific element from the XML by VB script

how to remove specific element for example need to remove NET2... element from the XML by VB I need to verify if NET2 element exist and then to remove it from the XML root version="3.0"> NET1 ID="172.17.202.1"/> NET2 ID="172.17.202.2"/> NET3 ID="172.17.202.3"/> /root> THX Yael ...

How can I store large amount of data from a database to XML (speed problem, part three)?

After getting some responses, the current situation is that I'm using this tip: http://www.ibm.com/developerworks/xml/library/x-tipbigdoc5.html (Listing 1. Turning ResultSets into XML), and XMLWriter for Java from http://www.megginson.com/downloads/ . Basically, it reads date from the database and writes them to a file as characters, usi...

How do I write unescaped XML outside of a CDATA

Hello I am trying to write XML data using Stax where the content itself is HTML If I try xtw.writeStartElement("contents"); xtw.writeCharacters("<b>here</b>"); xtw.writeEndElement(); I get this <contents>&lt;b&gt;here&lt;/b&gt;</contents> Then I notice the CDATA method and change my code to: xtw.writeStartElement("contents"); xt...

XML library similar to simplejson/json? - Python

Hi folks, is there a similar library to simplejson, which would enable quick serialization of data to and from XML. e.g. json.loads('{vol:'III', title:'Magical Unicorn'}') e.g. json.dumps([1,2,3,4,5]) Any ideas? ...

RESTful services architecture question

This is question more about service architecture strategy, we are building big web system based on rest services on back end. And we are currently trying to build some internal standards to follow while developing rest services. Some queries returns list of entities, for example lets consider we have image galleries retrieving service:...

XML + DOM + replace text in element

from XML <NET ID="10.10.10.10, 255.255.255.0" /> I need to replace the text 10.10.10.10, 255.255.255.0 with 192.9.1.1, 255.0.0.0 by VB + DOM script so the final line in the XML should be <NET ID="192.9.1.1, 255.0.0.0" /> THX ...