XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Neal WaltersSubject: Multiple items in return
Author: Neal Walters
Date: 02 Aug 2006 03:54 PM
I think this will be an obvious answer.

I'm learning this by example, and haven't seen any good examples with multiple variables in the return.

This is what I am trying:

<html>
{
let $file := doc("ISAFeed_July24B.xml")

for $item in $file//viewfmt
where $item/ccardex > ' '
order by $item/ccardex
return
<ExpireDate> {$item/ccardex} </ExpireDate>
<Acct>{$item/ftiacct}</Acct>
<Name> {$item/ftifnme} </Name>
<Price> {$item/itemprc} </Price>
<Amount> {$item/itemamt} </Amount>

}
</html>

It works fine when I have just one xml element and one value in the return.

The pop-up error says:
Syntax error, unexpected > (comparison operator), expecting "," or } [err:XPST00-3]

I'm guessing that it sees the "<" sign of "<Acct" as a less than sign?

Stylus Studio color-code every other xml pair of xml elements.
Do I have to use the concat function to string everything together?

I tried comma separating everything like this:

return
<ExpireDate> {$item/ccardex} </ExpireDate>,
<Acct> {$item/ftiacct}</Acct>,
<Name> {$item/ftifnme} </Name>,
<Price> {$item/itemprc} </Price>,
<Amount> {$item/itemamt} </Amount>
The Stylus Studio color look good, but error now says:
Syntax error, unexpected } [err:XPST0003]

Thanks,
Neal





Posttop
Ivan PedruzziSubject: Multiple items in return
Author: Ivan Pedruzzi
Date: 02 Aug 2006 04:27 PM
Neal,

You need to wrap the elements with parenthesis () to make it a sequence or with a root element

return
(
<ExpireDate> {$item/ccardex} </ExpireDate>,
<Acct> {$item/ftiacct}</Acct>,
<Name> {$item/ftifnme} </Name>,
<Price> {$item/itemprc} </Price>,
<Amount> {$item/itemamt} </Amount>
)


or


return
<record>
<ExpireDate> {$item/ccardex} </ExpireDate>
<Acct> {$item/ftiacct}</Acct>
<Name> {$item/ftifnme} </Name>
<Price> {$item/itemprc} </Price>
<Amount> {$item/itemamt} </Amount>
</record>


or


Ivan Pedruzzi
Stylus Studio Team

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.