xquery Questions
2
Solved
I am trying an XQuery using fn:matches with a regular expression, but the MarkLogic implementation of XQuery does not seem to allow hexidecimal character representations. The following gives me an ...
8
How to execute a XQuery in PHP? Can you give me an example?
Thank you.
2
Solved
Currently I have the following query:
SELECT
CASE
WHEN ('[Param.3]' = 'SELECTED')
THEN (SELECT RTRIM(XMLELEMENT("Rowset", XMLAGG(RW.R ORDER BY RW."ID")), ' ' ) AS Orders
FROM TMTABLE UL, XML...
4
Solved
Is it possible to put each XQuery result on a new line? I thought I remembered there was an attribute to set at the beginning of the document, but can't remember. :/
I have this .xq file:
(: decl...
Cineraria asked 7/2, 2012 at 19:12
2
Solved
In below XML:
<company>
<customers>
<customer cno="2222">
<cname>Charles</cname>
<street>123 Main St.</street>
<city>Wichita</city>
<...
7
I want to create a counter in xquery. My initial attempt looked like the following:
let $count := 0
for $prod in $collection
let $count := $count + 1
return
<counter>{$count }</counter&g...
2
Solved
XQuery, shared with XSLT and XPath 2.0 and later, supports various number data types, two of them are xs:double and xs:decimal. It is possible to cast an xs:double to an xs:decimal, as defined in h...
5
Solved
I have an XML document that contains the following
...
<foo>abc</foo>
...
If I evaluate
return $xml//foo
I get back
<foo>abc</foo>
Is there any way to get just abc ...
4
I've been trying to fetch node text values from this XML file:
<!DOCTYPE structure>
<data>
<x>
<id>1</id>
<nam>tytuł</nam>
<tab>21</tab>...
1
Solved
I have a SQLCLR scalar function that will steam an XmlReader that I need to shred on demand into an inline resultset. These XML objects are generated on demand so I can't use an XML index. It will ...
Nelsonnema asked 31/10, 2014 at 22:34
2
Solved
I am using SQL Server 2008 R2. My problem is that I want to count number of hits that i receive from XQuery query using FLWOR. For each hit, I want a consecutive number, like: 0,1,2,3,4...
My quer...
Chemmy asked 10/9, 2013 at 10:22
3
Solved
Can I use XQuery to query all XML files under a specific directory?
All the XML files have the same structure.
Also, from what I have seen you can XQuery many files but you need to write
the name...
2
Solved
I have a simple query:
WITH xtbl AS (
SELECT XMLTYPE ('<a><b>1</b></a>') AS xcol
FROM DUAL
)
SELECT XMLQUERY ('copy $tmp := .
modify
insert node <c>2</c>...
1
Solved
I have the following XML data and the Element table.
DECLARE @input XML = '<root>
<C1>
<C2>
<C3> <C4>data1</C4> </C3>
</C2>
<C2>
<C3...
Leesaleese asked 19/7, 2014 at 14:28
3
Solved
I need to retrieve some details from a MusicXML (xml) file in Java.
I managed to read xml files in java - but through a web service (where I have to be online, connected to internet when I'm runni...
Bev asked 28/6, 2010 at 23:42
2
Solved
I know how to do it in the simplest scenario, e.g.
DECLARE @commaSeparatedValues NVARCHAR(MAX)
DECLARE @xml XML = N'<id>1</id>
<name>test</name>
<istest>1</istest&...
Gallstone asked 9/4, 2014 at 8:30
1
Solved
There is a question somewhere on Stackoverflow, although i cannot find it now, that reminded the poster that .value does not return the value that .exists.
That is because .value is always written...
Escrow asked 5/5, 2014 at 23:3
3
Solved
I know that I can search for a term in one column in a table in t-sql by using like %termToFind%. And I know I can get all columns in a table with this:
SELECT *
FROM MyDataBaseName.INFORMATION_...
Touchmenot asked 30/8, 2013 at 12:26
4
Solved
Suppose I have this table [Table1]
Name Mark
------- ------
ABC 10
DEF 10
GHI 10
JKL 20
MNO 20
PQR 30
What should be my SQL statement to retrieve a record that looks like this:
(group by [mark])...
Hailstorm asked 5/7, 2011 at 7:51
1
Solved
for the below data -
let $x := "Yahooooo !!!! Select one number - "
let $y :=
<A>
<a>1</a>
<a>2</a>
<a>3</a>
<a>4</a>
<a>5</a&g...
Sophistry asked 14/1, 2014 at 13:51
2
Solved
I need the name of the element is also a variable (is a parameter of the procedure)
Instead of this, which works fine:
DECLARE @VAR VARCHAR(5)
SET @VAR = 'false'
UPDATE CURVES
SET CURVEENTITY.mo...
2
I am using marklogic 4 and I have some 15000 documents (each of around 10 KB). I want to load the entire content as a document ( and convert the total documents to a single csv file and output to H...
1
Solved
I am generating a XML file from a SQL Server query.
I have some problem about sorting elements issues.
For example, there is simple code as below.
<test>
<tree abc="123"/>
<tree...
Rysler asked 16/12, 2013 at 14:21
3
Solved
In MarkLogic, is it possible to bind a cts:search expression to a variable and then use that variable elsewhere in the XQuery?
I want to do something like this:
let $query := cts:search(doc(),
c...
Hydracid asked 11/12, 2013 at 13:12
4
Solved
I have some properties of an application being passed to me in XML form. I need to parse out the property by name and assign the value to the appropriate column in my database.
I am currently pars...
Gebelein asked 27/6, 2013 at 20:11
© 2022 - 2024 — McMap. All rights reserved.