xquery Questions
1
Solved
I have a table, SECTION_ANSWER, in an Oracle 11g database which has an XMLType column. The XML is pretty simple, it follows the structure:
<section sectionID="1">
<question questionID="1...
Hl asked 3/12, 2013 at 16:24
3
Solved
I would like to know if xquery FLWOR expression has an exit statement like continue and break?
For example I want to exit the for loop when a particular condition is reach.
1
Solved
I am getting my desired schema. But the one thing i need to do is to eliminate duplicate values. Hence I use distinct values, but what that function does is it displays all the values within one el...
Carrelli asked 2/11, 2013 at 3:9
1
Solved
Is there a way with MarkLogic to not have to prefix every single fn: function with that prefix? I've seen lots of codes on the Internet that show me that I don't need it.
Things can get rather ver...
4
Solved
I've been working with a document repository using XQuery (via Java and .NET interfaces) and was wondering if anyone has any recommendations for unit testing XQuery modules?
Adige asked 4/2, 2009 at 23:32
1
Solved
Sorry even trying to watch tutorials I am just trying to understand the difference between the data() and the text() functions in XQuery.
Any clarification is appreciated.
2
Solved
I have a table where ID is integer and XML is XML data type.
ID XML
----------------------
1 <Form1>...</Form1>
2 <Form1>...</Form1>
3 <Form2>...</Form2>
4 <...
Wellchosen asked 6/9, 2013 at 7:39
1
Solved
This is my sample XML:
<root>
<element>
<subelement>
<value code="code1">value1</value>
<value code="code2">value2</value>
</subelement>
</...
Autography asked 3/9, 2013 at 7:41
1
Solved
I've got some XML Data in a SQL Server Table in an XML Column as follows:
<AffordabilityResults>
<matchlevel xmlns="urn:callcredit.co.uk/soap:affordabilityapi2">IndividualMatch</ma...
Damascus asked 6/8, 2013 at 18:30
3
Solved
How can I update the value of an xml tag with the value of an xml tag from another related table?
something like this:
UPDATE v2
SET
[xml].modify ('replace value of (//TAG1/text())[1]
with "C...
Makeshift asked 16/6, 2010 at 3:40
1
Solved
I want to get or return the number of item(<recROw></recROw>) in an xml file using the XQUERY. Is there an easy way to do that in XQuery?
Here is my sample XML data:
<?xml version=...
3
XRX means an application where the front end is written entirely in XML dialects and the back end is written entirely in XML dialects and data is passed between them as XML over REST.
Is it correc...
1
Solved
I'm having a table (let's call her t) that contains the fields id(int) and XmlField(xml).
I try to add multiple node in one query but no matter what I tried I keep getting errors.
The query is:
...
Accusative asked 3/6, 2013 at 15:34
3
Solved
My XQuery is:
declare namespace xsd="http://www.w3.org/2001/XMLSchema";
for $schema in xsd:schema
for $nodes in $schema//*,
$attr in $nodes/xsd:element/@name
where fn:contains($attr,'city')
retu...
Biedermeier asked 1/6, 2013 at 14:32
3
Solved
Is it possible to use anchors inside a character class? This doesn't work:
analyze-string('abcd', '[\s^]abcd[\s$]')
It looks like ^ and $ are treated as literal when inside a character class; h...
1
Solved
I am struggling with this now: How do you replace the value of a node in an untyped XML column where the text is equal to a certain variable value? Is it possible?
My XML:
<attrs>
<attr...
Aparri asked 15/3, 2013 at 14:54
2
Solved
My application often needs to decorate values in the documents it serves using a lookup take to fetch human readable forms of various codes.
For example <product_code>PC001</product_code&...
2
Solved
I'm using the following code to load in an XML file (actually an NZB):
QXmlQuery query;
query.bindVariable("path", QVariant(path));
query.setQuery("doc($path)/nzb/file/segments/segment/string()")...
1
I am involved in a project maintenance plan that involves either major refactoring or complete redesign. We have a very complicated existing technology stack that has evolved organically over a per...
Gregoor asked 31/1, 2013 at 17:0
2
Solved
7
Solved
I was answering some quiz questions for an interview, and the question was about how would I do screen scraping. That is, picking content out of a web page, assuming you don't have a better structu...
Johan asked 14/3, 2009 at 18:55
1
Solved
This is the structure of my XML file -
<A>
<Name t="Mr.">James Bond</Name>
<Name t="Mr.">Allen Bond</Name>
<Name t="Mr." p="X">James Bond</Name>
<N...
1
Solved
I am using SQL Server 2008 and I want to retrieve XML elements and return the element itself and its attributes without any sub elements and without the text(). Eg the following XML has 4 nodes (do...
Castello asked 16/12, 2012 at 23:4
3
Solved
Im looking to form an xQuery which returns the category of a book if this category contains more than x amount of books. For example if I have 4 categories; music, film, education, health and they ...
Piscator asked 8/12, 2012 at 23:16
2
Solved
I have a simple xml in a XML column
<Bands>
<Band>
<Name>beatles</Name>
<Num>4</Num>
<Score>5</Score>
</Band>
<Band>
<Name>d...
Kattiekatuscha asked 27/11, 2012 at 22:58
© 2022 - 2024 — McMap. All rights reserved.