xquery Questions
4
Solved
I need to word wrap long string to 100 characters using XQuery. In other words, to change some spaces to newlines so that the non-patological lines will be shorter than 100 characters. Is there an ...
Interpretive asked 22/9, 2010 at 8:18
1
Solved
I can't find an explanation on the following. I've made this test script in order to solve my previous question.
xquery version "3.0" ;
declare default function namespace 'local' ;
declare functi...
Denominative asked 11/1, 2018 at 2:40
1
Solved
I raise this question after multiples tests in order to verify that my expression is correct. And it is, although it still doesn't go through.
I'm using the classic dispatch/passthru function to c...
Alexandriaalexandrian asked 10/1, 2018 at 15:12
3
Solved
This SQL only returns the first Activity element. How do I select them all? If I remove the [1] in the query I get an error that "value() requires a singleton".
DECLARE @myDoc xml
SET @myDoc = ...
Overture asked 8/9, 2009 at 10:40
2
I have two xml variables:
@main xml = '<root></root>'
@insert xml = '<rows><row>SomeRow</row></rows>'
And I would like to insert child nodes of @insert rows, ...
Cavein asked 22/7, 2016 at 8:17
4
Solved
It sounds like I need some type of XML processor
It looks like theres a program called Saxon which I can use to run XQuery
When I try this websites example I get
Error: Could not find or load m...
Carhop asked 6/6, 2017 at 0:48
3
Solved
XQuery offers various date/time functions like current-dateTime(), however I can't seem to find one which gives me the time in milliseconds since Epoch. Functions to extract hours, minutes and seco...
2
Solved
I have data like:
<td>USERID</td>
<td>NAME</td>
<td>RATING</td>
I want to transform it into:
<userid></userid>
<name></name>
<...
4
Solved
I am using XML and XQuerie. I usually use an XPath expression relative to a parent node to retrieve its child node. But, I am not sure how to do the opposite meaning if I have a child node, how do ...
Sedda asked 14/9, 2010 at 20:5
3
Solved
How does one retrieve the text in a node without selecting the text in the children?
<div id="comment">
<div class="title">Editor's Description</div>
<div class="changed">...
7
Solved
I have an XML document I generate on the fly, and I need a function to eliminate any duplicate nodes from it.
My function looks like:
declare function local:start2() {
let $data := local:scan_bo...
Overprize asked 13/3, 2009 at 20:3
3
Solved
The (BaseX) error
I am running queries on a large dataset in BaseX, but one XQuery is crashing my programme with an error [XPTY0004] Item expected, sequence found: (attribute begin {"6"}, ...)..
...
3
I do not find an example for my problem so here is my question.
I get an error that else is an unexpected token in the following example:
let $var1 := 'true'
if ($var1 = 'true') then
let $var2 :=...
Dissimilation asked 16/3, 2017 at 11:31
2
I have a Table with an XML column,
I want to update the xml to insert attribute or to change the attribute value if the attribute already exists.
Let's say the starting xml is: < d />
Insertin...
Dustidustie asked 4/10, 2010 at 10:25
3
Solved
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 CS...
2
Solved
I have looked everywhere for help on this.
I'm new to all this and I'm finding it hard to understand all the documentation on it.
Say I have this XML:
<footballteams>
<team manager="Be...
Melosa asked 24/6, 2012 at 16:34
2
Solved
I have a scenario where most of the documents i want to delete are in a collection called "expired". I do not want to overload my servers by running a long running process which would iterate over ...
Demit asked 19/9, 2016 at 10:43
1
I want to create a translator from SQL to XQuery.
I want to parse SQL and generate an intermediate structure and then use it to generate the XQuery query.
(Note- I want to use an intermediate repre...
Endres asked 19/9, 2016 at 11:39
2
Solved
I have some XML that I need to parse using SQL Server 2008. I think I'm close to getting what I want, but I don't have the correct syntax (I believe).
I have the following:
DECLARE @doc XML
SET @...
Banking asked 18/10, 2012 at 21:21
1
Solved
Oracle version 11.2
Below is a cut down version of an XMLQuery i'm running on an XMLType column. When I run the query, which simply parses and recreates the stored XML, the tsxm namespace (that is...
Faunia asked 28/7, 2016 at 9:43
1
Solved
I have 1581 words that I need to look up in an XML corpus of Dutch (500 million words). This corpus itself is split up in many databases. (You can read why here.) We use BaseX as a server (version ...
4
Solved
What is the difference between XPath, XQuery and XPointer? As far as I know, XQuery is an extended version of XPath. I have some basic knowledge of XPath. Is there any feature available in XPath wh...
3
Solved
I store my entities in the eXist XML database and I use a file name (resource id) as an ID of an entity.
Example:
String xquery = "for $movie in collection('/db/movie')//movie "
+ "return $movi...
3
Solved
Assume this table:
PruchaseID | Customer | Product | Method
-----------|----------|----------|--------
1 | John | Computer | Credit
2 | John | Mouse | Cash
3 | Will | Computer | Credit
4 | Wil...
Underscore asked 7/6, 2016 at 16:24
6
Solved
How can I find the order of nodes in an XML document?
What I have is a document like this:
<value code="1">
<value code="11">
<value code="111"/>
</value>
<value co...
Mylohyoid asked 15/7, 2009 at 21:3
© 2022 - 2024 — McMap. All rights reserved.