My XML file entry: <GlobalView xmlns="http://schemas.openxmlformats.org/package/2006/relationships"> <rels> <Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" Target="docProps/app.xml"/> </rels> wanna query attribute Id inside Relationship element...
I am thinking of storing bunch of data in XML files. Each file will has information about a distinct element lets say contacts. Now I am trying to do retrieve a contact based on some information eg: Find all the contacts who live in CA. How do I search for this information? Can I use something like LINQ. I am seeing XElement but does it ...
If I add two documents to a BaseX DB, let's say normal.xml and normal2.xml, is there a way to refer to each one individually? I know about the doc() function, but it looks at the filesystem for their location, rather than in the database itself. For instance, if I query with this: doc("normal.xml")/name, then I will get an error about ...
How can I retrieve the fields within an XML field in MS SQL? Every query I try does not work as intended whenever I use this XML code: I want to select the AccNumber value. <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSch...
There is probably a very easy solution for this problem. I could easily do this in C#-LINQ. Unfortunately, I'm not so experienced with XPath and XSL. I have an input XML file that contains the following structure: <group> <val>1</val> <val>3</val> <val>1</val> </group> <group> <val>3</val> <val>2</val> <val>2</v...
I have been using zorba for a little while and it seems to generally work. But it seems to leak memory here and there and I am having to look at other options. Has anyone had luck with any other XQuery engines in linux environment? ...
I have this XML in a SQL Server table: <root> <meetings> <meeting> <id>111</id> <participants> <participant><name>Smith</name></participant> <participant><name>Jones</name></participant> <participant><name>Brown</name></participant> </participants> </meeting> <meeting> <id>22...
Hi guys In a Proxy Service If for example the input is: [Employee] [Name]Test[/Name] [ID]ID[/ID] [Address]test add[/Address] [Email]test@test[/Email] [Department]Testh[/Department] [Department]Test 2[/Department] [Department]Test 3[/Department] [Department]Test 4[/Department] [/Employee] If there's mu...
I think Xquery has not the "AND" operator and i cant do this: if node1 = xxx and node2 = yyy and node3 = zzz then replace node3 with www ...
Hello, I have a variable parameter that is formatted to the date type in XML. I need to convert that parameter into the dateTime format for another variable to accept my copy operation. This is being done in BPEL, but the expression builder for XQuery should be the same regardless of the processing language. Thanks very much for any h...
Hello, I have XML for example: <types> <type type="A"> <type type="A.A"/> <type type="A.B"> <type type="A.B.A"/> </type> <type type="A.C"/> </type> </types> Now, I have input string like: "A.B.A". I want get all ancestor and self node which has this string like value of "type" attribute. It means: <types> ...
I want to append the values of some XML tags, and then append again the result. But I'm having some trouble appending the results, so I only have one final result of appending. Imagine you have this: <nodeA> <nodeB> <item>1</item> <item>2</item> <yesno>blah</yesno> </nodeB> <nodeC> <thing>A</thing> </nodeC> </nodeA> <nodeA> <nodeB...
Hi all, I wan t to upload the xml data to the sql table. I am passing the xml data from .net(c#)(Working fine) code: ALTER PROCEDURE [dbo].[BookDetails_Insert] (@xml xml) AS insert into BookDetails (Pages,Descriptions) SELECT ParamValues.PLName.value('.','int'), ParamValues.PLDEscr.value('.','text') FROM @xml.node...
Do you know any good XPath Query resources/starting guides for beginners ? Books / websites .. No php manual/google answers pls. ...
I planning to using XQuery in J2EE web application running on WebLogic 11g. I know WebLogic has XQuery implementation but couldn't find any link on how to use them. I am looking for sample & package/class I need to start with. ...
My xquery script opens several files. One of the files is sometimes missing. I need to test whether the file exists before I try to open it. (something like -f in bash or perl). Is it possible? ...
I would like a brief and easy way to strip tags from an XHTML document, and believe there has to be something curt enough among all the options like: XSLT, XPath, XQuery, custom C# programming using the .NET XML namespace. I'm open to others. For example, I want to strip all <b> tags from an XHTML document but keep their inner cont...
I have an xml file <?xml version="1.0" encoding="utf-8"?> <xml> <events date="01-10-2009" color="0x99CC00" selected="true"> <event> <title>You can use HTML and CSS</title> <description><![CDATA[This is the description ]]></description> </event> </events> </xml> I used xpath and and xquer...
Is there any implementation of XQuery known to work with the Android SDK? I tried mxquery, but had no luck. I did not expect it to work as their site says Andriod support comming soon. I'm unsing jTidy to parse web pages into XHMTL and am looking for something lite and fast to search, filter and reformat XML files. Thanks. ...
I am new to programming. I know what XML is. Can anyone please explain in simple terms what xpath and xquery do Where are they used? ...