Re: [xquery-talk] Add value to result before a for loop

[David Carlisle]

On 18/07/2012 13:49, Gary Larsen wrote:
Hi,
I can’t seem to find valid syntax for output of a value before a for
loop.  In this example I want to output a header line ($hdr) to the results.

Thanks for your help,

Gary

let$doc :=
<doc>
<item><id>1</id><name>item 1</name></item>
<item><id>2</id><name>item 2</name></item>
</doc>

let$hdr :=concat('Id', codepoints-to-string(9), 'Name',
codepoints-to-string(10))

for$i in$doc/item return
concat($i/id, codepoints-to-string(9), $i/name, codepoints-to-string(10))


for is just an expression so you could for example use
concat($hdr,for $i in ......)

of course in this simple example you don't need the variable at all as 
$hdr is already just a call to concat you could return the single expression

concat('Id', codepoints-to-string(9), 'Name',
 codepoints-to-string(10),
for $i in$doc/item return
concat($i/id, codepoints-to-string(9), $i/name, codepoints-to-string(10)
)

or more simply

string-join(
('Id&#9;Name',$doc/item/concat(id,'&#9;',name)),'&#10;')

the let and for clauses aren't really needed,

David




--
google plus: https:/profiles.google.com/d.p.carlisle

________________________________________________________________________
The Numerical Algorithms Group Ltd is a company registered in England
and Wales with company number 1249803. The registered office is:
Wilkinson House, Jordan Hill Road, Oxford OX2 8DR, United Kingdom.

This e-mail has been scanned for all viruses by Star. The service is
powered by MessageLabs. 
________________________________________________________________________
_______________________________________________
talk@x-query.com
http://x-query.com/mailman/listinfo/talk