XQuery Help and Discussion en-us http://www.stylusstudio.com:80/SSDN/default.asp?action=10&fid=57 360 XQuery Help and Discussion http://www.stylusstudio.com:80/SSDN/default.asp?action=10&fid=57 http://www.stylusstudio.com:80/SSDN/Images/rss.gif WORKED!! You are awesome. Thank you! ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8835&fid=57#27878 Ok, I will give this a shot today and will let you know. Thanks again. ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8835&fid=57#27870 Hi Steve, your pseudo code should be changed into this: for each department tokenize the item list into a list of items then sum all the prices associated to the item nodes that belong to that list This is the corresponding XQuery code: for $dept at $index in /root/dept return <dept name='{$index}'> { let $items := tokenize(f ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8835&fid=57#27868 Hi Alberto, thanks for responding. In a nut shell this is what I have. <dept> <items>PS3, PSP, XBox, Wii</items> </dept> <dept> <items>PS3, XBox</items> </dept> <dept> <items>Wii</items> </dept> <dept> <items>PSP, Wii</items ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8835&fid=57#27866 Hi Steve, in XQuery (and XSLT) you work on set of nodes, so you can compute the sum once you have written down the XPath query that highlights the prices of the items of department D. If you post the XML fragment, we could tell you such a query. Alberto ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8835&fid=57#27864 I am having a hard time returning a value based on certain conditions. SORRY FOR THE LAME EXAMPLE... I have a group of departments which contain certain items. Dept A: PS3, PSP, XBox, WII Dept B: PS3, XBox Dept C: WII Dept D: PSP, WII Each of these items have a price. I want to return the total for each department. So, lets say PS3 = $300[b ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8835&fid=57#27862 Hi, could you send us the query and the source XML to stylus-field-report@progress.com so that we can investigate the issue? Thanks, Alberto ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8832&fid=57#27846 Why does a simple query stop with a Java heap space message? How can this be corrected? ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8832&fid=57#27844 Ohmigosh!!! This is EXACTLY what I was looking for. Thank you so much. ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8820&fid=57#27786 Hi Martie, Have a look at this post http://blogs.datadirect.com/2007/12/xquery-generating-multiple-xml.html Hope this helps! Ivan Pedruzzi Stylus Studio Team ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8820&fid=57#27783 That made it! I understand I have some learning to do. Thanks. Now I can try out the Stylus Studio to see if it will be of use to me, - and I think it will. :-)arjo ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8814&fid=57#27778 Hi everyone I've had a huge amount of fun playing with this product over the past 2 days. My XML is a little rusty at the moment and this has been my first exposure to XQuery, so my question might seem a little silly, but here goes. I have a database full of data originally derived from hundreds of Infopath forms, saved as XML. Due to a hardware catastrophy, the original XML- ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8820&fid=57#27777 Hi, your XML is using a default namespace (see the xmlns='http://www.npr.no/xmlstds' declaration in the top level element), so you should write a query like this: declare namespace p = 'http://www.npr.no/xmlstds'; doc('file:///C:/Program Files (x86)/DataDirect ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8814&fid=57#27772 To simplify things, I have removed most of the file (it's rather big). And I have altered sensitive data in it, but all the elements etc are present. The file looks like this: ********** <?xml version='1.0' encoding='utf-8'?> <Melding versjon='47.0.3' fraDatoPeriode='2009-01-01' uttakDato='2009-09-23' kontPerson='Borte Bra' meldEpost1='en@adresse.no' meldRefNr='2004-3 ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8814&fid=57#27766 Can you show us the query and XML? Ivan Pedruzzi Stylus Studio Team ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8814&fid=57#27762 Hi. I am new to Stylus and XQuery. Have downloaded Stylus Studio 2010 Enterprise Suite for evaluation and training because I need to query xml-files. I perform xqueries against the example-files in Stylus, and get returns. But when i query my local xml-file, I get no return. The query processes without returning any errors, and the file checks out as 'well formed'. And I can open it in Tree-view a ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8814&fid=57#27759 Hi, you can definitely open both files (using XML Converters to convert the CSV into XML) and then locate the values you need from the CSV using XPath to build a merged view of both files. Alberto ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8804&fid=57#27751 could anybody help me? Thanks...! ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8804&fid=57#27731 I have a csv file with 2 collumns. 1 artikel code, 1 article description. I have also an exported XML file with a lot of information about many articles. The description field in the XML is now empty. is it possible to fill the description field of all the articles in the XML with data from the CSV? Thanks a lot! ... http://www.stylusstudio.com:80/SSDN/default.asp?boardid=1&action=9&read=8804&fid=57#27717