XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » XQuery on all XML Files in a Directory?
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2016)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-> + Problems with FTP upload via X... (3)
-> + What path notation works when ... (6)
-> - Xquery Exception (1)
-> + [java] [Fatal Error] Test.xml:... (2)
-> + unable to produce correct XML ... (2)
-> + where can I find stylusxql uti... (3)
-> + Trouble Mapping Multiple Eleme... (3)
-> - input parameter (1)
-> - set element value (1)
-> + Xquery Performance Issue (21)
-> + Run Xquery Program using Java (3)
-> + XQuery XML to CSV (3)
-> + XQuery MySQL connector (4)
-> + XQuery with JDBC connection is... (3)
-> + Create FTP Server (2)
-> + XQuery Nested Loop Lookup (5)
-> + Xpath using a Variable for [@I... (2)
-> - My xqDoc option is disabled. (1)
-> + Xpath ancestor selection (4)
-> + Exception: sequence of more th... (2)
-> + XQUF usage (3)
-> - xquery rule execution (1)
-> + Loving XQuery (3)
-> + Cross Referencing Country Name... (4)
-> + Creating a Pivot Table with xQ... (2)
-> + Error Please Help (3)
-> - Error Please Help (1)
-> + XPath descendant question (2)
-> + java/lang/OutOfMemoryError Run... (2)
-> + Xquery key value lookup (8)
-> + Improve xQuery Performance (3)
-> + MS SQL Server - Disable order ... (10)
-> + proper use of fn:distinct-valu... (2)
-> + Ignore DTD (7)
-> - Thanks Ivan (1)
-> + Trying to get 2nd value of nod... (5)
-> + Outer joins (4)
-> + Figured Out Issues From Last P... (2)
-> + Best Way To Generate Complex X... (3)
-> + count in xquery (4)
-> + left/right presentation (3)
-> + new to stylus - connecting to ... (2)
-> + XQuery problem with namespaces (4)
-> + .conv and xquery problem (3)
-> + Can pass text into CONV file (2)
-> + doc-available not working as e... (4)
-> + ddtekjava write to file only e... (5)
-> + arrayindexoutofbounds with ddt... (7)
-> + XSD: Structure definition depe... (2)
-> + Fatal Error whitespace expecte... (3)
-> + Executing a pipeline sequence ... (2)
-> - Data Transfer (1)
-> + Specifying the SEF File Locati... (4)
-> + Multiply numbers... (2)
-> + Using Generated Java-Code... (5)
-> + Mapper does not show all nodes... (5)
-> - Xul tree search using XQuery X... (1)
-> + converting XML to CSV (2)
-> - datadirect licenses (1)
-> + generate a uuid (2)
-> + Help to write Xquery (2)
-> + XQuery java ddtek:serialize-to... (2)
-> + EDI to XML Automation (2)
-> + Generating XQUERY to use in Or... (2)
-> + Stylus is not easy to learn XQ... (2)
-> - java.lang.OutOfMemoryError (1)
-> + how to save to xml format (2)
-> + Formating a date in xquery (2)
-> + two xml statements when mappin... (5)
-> + XQuery (2)
-> + saxon-license.lic Not Found (2)
-> + hands off conversion to final ... (2)
-> + fn:substring in XQuery to Orac... (4)
-> + Using Saxon with XQuery to ins... (4)
-> + Can't SAVE or DO a SAVE AS Fro... (2)
-> + Saxon Unexpected token < e o f... (2)
-> + Inserting and selecting data i... (2)
-> - convert sql statement into xml... (1)
-> + need help in converting this a... (2)
-> + IS IT POSSIBLE TO DO AN XQUERY... (2)
-> + XQUERY RESULTS NOT IN PROPER F... (2)
-> + how to get data from database ... (2)
-> + tree view in xquery (2)
-> + Need help with SelectsingleNod... (5)
-> - counting in query (1)
-> + WebApplication with Xquery (3)
-> + Limit to number of elements in... (3)
-> + Automate xquery Conversion (2)
-> + ddtek:wscall problem (2)
-> - Problem with case sensitive (1)
-> + Is this the formal tech suppor... (2)
-> + problem with Conditional Expre... (5)
-> - problem with Conditional Expre... (1)
-> + connect to mysql for xquery? (2)
-> - NOOB Help (1)
-> - Getting rid of empty namespace... (1)
-> + Xquery not yielding results (3)
-> - fn:replace() inserting spaces ... (1)
-> + Xquery XML document with spcei... (7)
-> + XLS (MS Excel) to XML Converte... (3)
-> + Little Help :))) (2)
-> + Xquery tag position (2)
-> - Can I connect to MonetDB/XQuer... (1)
-> + Is there a way to format a num... (2)
-> + Please help convert SQL query ... (3)
-> + Connect to SQL Server Express ... (3)
-> - Convert HTML to XML within C# ... (1)
-> + return different result based ... (7)
-> + Java Heap Space (2)
-> + XQuery Results export to multi... (3)
-> + NO RETURN (5)
-> + Part of a csv into a current X... (3)
-> + How to escape ampersand in xqu... (2)
-> + How to Convert CSV lines to in... (5)
-> + Data connection Stylus Studio ... (2)
-> + Nested XQuery FLOWRs with RDBM... (3)
-> + observing xquery at work (2)
-> + alternative for 'exists' (4)
-> + Xquery and webpages how? (2)
-> + Help with another DataDirect p... (5)
-> + How to resolve XPTY0004 error (3)
-> + Search a sequence of siblings ... (3)
-> + DataDirect process getting XPS... (2)
-> + Find the parent who doesn't ha... (3)
-> + Help with a basic FLWOR query (3)
-> + xQuery Efficient Performance B... (5)
-> + How to break down a sequence a... (3)
-> + Xquery returning odd number fo... (2)
-> + Problems with Java date parame... (3)
-> + Xquery filter on multiple valu... (2)
-> + Xquery filter by using contain... (5)
-> + multiple xslt execution using ... (2)
-> + How to access to global variab... (6)
-> + "Value can not be converted to... (4)
-> + (simple) problem with xquery (3)
-> + Version of xQuery Included wit... (3)
-> + xQuery 1.0 Produces XPTY0004 E... (3)
-> + Replace Node with Set of Nodes (2)
-> + Unable to Use File Name as Ext... (5)
-> + EDI to XSD and validation (2)
-> + Sample XQuery extension using ... (2)
-> + Another EDI problem (7)
-> + Removing xmls:od and xmls:xsi ... (2)
-> + Configuring MarkLogic with Sty... (10)
-> + EDI to XML (7)
-> + Can't write to SQL-Server (4)
-> + XQuery and SQL-Server (2)
-> + Connection to MS SQL Server in... (2)
-> + copy/modify with Stylus Studio... (5)
-> - copy/modify with Stylus Studio... (1)
-> + [SQLServer JDBC Driver]Value c... (5)
-> + wild card chracter usage in XS... (2)
-> + Xquery with SQL NEWID function (4)
-> + Change Only One Line (5)
-> + Format DB xQuery results (3)
-> + Adding MsSQL Database to XQuer... (3)
-> + Need help with using XQuery in... (2)
-> + please help! simple XML transf... (2)
-> + xquery for invoice data (3)
-> + Xquery to cross reference two ... (3)
-> + how to list distinct value? (5)
-> + Reading XML Files Across Netwo... (8)
-> + I want to automatically check ... (4)
-> + Parent tags (5)
-> + Remove Empty tags (2)
-> + dynamic function call | dynami... (3)
-> + Can I define a function like f... (3)
-> + remove empty tags (4)
-> + Loops (7)
-> + flat to XML with xQuery (4)
-> + Xquery for timer based events. (2)
-> + Cleaning up Word 2007 xml (3)
-> + Xquery string-pad function (5)
-> + DB to XML Data Source (2)
-> + XML Streaming not working (2)
-> + XQuery General Question (11)
-> + ERROR XQueryMediator Error dur... (2)
-> + Print Date in XML File (2)
-> + Aritmetic in Xquery (2)
-> + Use content of node as node na... (2)
-> + Better way to do this? (3)
-> + Get output line by line!! (2)
-> + Use of if-then-else (2)
-> + Manipulation of XQuery output!... (4)
-> + Subtract times (6)
-> + Using xQuery to call a Convers... (3)
-> + How to add a custom class to t... (3)
-> + How to get rid of multiple occ... (2)
-> + Problem with conditional JOINi... (8)
-> + XQuery editor whitin Stylus St... (3)
-> + Get rid of spaces in returned ... (4)
-> + Can XQuery be embeded in a Jav... (2)
-> + Need help on converting <br... (3)
-> + postgresql (3)
-> + No format-number functionsupp... (4)
-> + Swapping elements using XQuery... (2)
-> + Trying to contact DataDirect d... (3)
-> + External Java functions with b... (5)
-> + Looking for xQuery help (6)
-> + Built-in processor & filtered ... (2)
-> + Multiple Sibling Matches (2)
-> + Issue with data($element) (4)
-> + convert text to xml from more ... (2)
-> + xquery syntax (2)
-> + SQL Table To XML using XQuery (4)
-> + delimiting values of attribute... (3)
-> + empty child nodes (9)
-> + Illegal XML characters (4)
-> + Complete SQL Server database t... (34)
-> + Prevent xquery from converting... (8)
-> + Another edi question. (6)
-> + Running xquery with a source c... (4)
-> + xml to edi segment count quest (3)
-> + Running xquery from the comman... (7)
-> + How to change the node name in... (5)
-> + How to loop through a set of e... (10)
-> + Can I pass a parameter/vaiable... (3)
-> + generating an XML file (3)
-> + generating log files of Xquery... (2)
-> + Stylus Studio crashes when edi... (3)
-> + Checking for Values in an Arra... (3)
-> + Adding embedded functions (11)
-> + multiple DTPs at the same leve... (2)
-> + java.lang.OutOfMemoryError: Ja... (3)
-> + xml validation against wsdl (2)
-> + Using same Xquery (4)
-> + Changing name value pairs to t... (4)
-> + removing unwanted attributes r... (4)
-> + Repeated Crashing of System (2)
-> + Create multiple XML Files (5)
-> + Best xQuery engine? (2)
-> + Xquery outputs XML attributes ... (4)
-> + DataDirect SequeLink as a DB-t... (2)
-> + Using same xquery for 2 xml fi... (5)
-> + Performance of XQuery (2)
-> + fail to use Saxon Process for ... (4)
-> + Conditional statements in xque... (2)
-> + Option Declaration Using Saxon (2)
-> + Multiple option declarations (2)
-> + Importing modules with a Custo... (3)
-> + Possible bug: Problem with aut... (5)
-> + getting the value of an attrib... (4)
-> + Memory problems using xQuery (6)
-> + Adding a namespace (6)
-> + [DataDirect][XQuery][err:FODC0... (9)
-> + Mapping Trouble (4)
-> + Two level grouping (5)
-> + Error: A parameter of the oper... (3)
-> + Grouping in xQurey (Nested For... (7)
-> + err:XPST0005 - Error at line 9... (4)
-> + Error at line 1, column 126. U... (6)
-> + Strange output (2)
-> - word count for each category (1)
-> + Need help with this xquery (2)
-> + XML DOM (3)
-> + License issues related to XQue... (3)
-> + XQuery, ddtek:wscall, and an e... (9)
-> + How to give sub equation nos (3)
-> + XML DOM (3)
-> + forcing empty elements to have... (4)
-> + SQL Server 2005 XQuery help (4)
-> + Type error (5)
-> + MarkLogic queries (2)
-> + relative uri (3)
-> + Recursive Template Funcion Fro... (2)
-> - Create RDF for xml (1)
-> + Schema validation errors (2)
-> + KEYWORD EXTRACTION FROM XML DO... (6)
-> + Newbie struggling with nested ... (4)
-> + Path evaluation bug (?) concer... (2)
-> + XPath query (3)
-> + make sequence (4)
-> + XPath Query Editor Schema-Awar... (3)
-> + Newbe To This Form of programm... (2)
-> + Connection to remote database (2)
-> + Addnamespace using xquery (4)
-> + FATAL ERROR: Invalid document ... (3)
-> + FLOWR Loop Counter (5)
-> + Stylus Studio XML generation f... (2)
-> + Potential bugs? (2)
-> + hierarchical XML into tables (2)
-> + Incremental line counts (4)
-> + preceding-sibling syntax help ... (2)
-> + Creating hierarchical identifi... (5)
-> + Convert decimal to Hex. (3)
-> + XQuery automated comparison of... (3)
-> + validating schemas (2)
-> + very simple fn:string() proble... (5)
-> + Need help with a XSL file (2)
-> + Problems with conversion from ... (3)
-> + MS Sql Server (2)
-> + XQuery equivalent of xsl:resul... (2)
-> + tokenizing a string - problem ... (3)
-> + XQuery and eXist error process... (2)
-> + Deploying an xquery file with ... (2)
-> + Newbie struggling with simple ... (4)
-> + summing up the figure in the n... (8)
-> + Variable as part of a tag? (2)
-> + xquery element tag name (2)
-> + xquery - question for count fu... (3)
-> + get multiple values from multi... (4)
-> + Is it possible to add new data... (7)
-> + Can't connect to DB - MS SQL S... (16)
-> + sequence distinct values (4)
-> + XSQL QUERY (2)
-> + External xquery functions (2)
-> + Error in Xquery V3.0 (7)
-> + Problem getting distinct value... (2)
-> + XQuery reference book recommen... (2)
-> + it's possible to have a where ... (2)
-> + XSLT sorting parent nodes by m... (2)
-> + Catalyst EDI Mapping (2)
-> + h2 element is there but XQuery... (2)
-> + Adding the XML header to an ou... (2)
-> + Newbie question regarding dyna... (2)
-> + Group parent elements in targe... (5)
-> + Need XPath to return just imme... (4)
-> + XQUERY Java run-time error (4)
-> + dbxml and collection() (2)
-> + Nothing returned when namespac... (3)
-> + XQERY and Stylus Studio suppor... (3)
-> + x12 837 convert to xml fail wi... (3)
-> + Choose more than one attribute (2)
-> + XQuery Engine (4)
-> + finding nodes in source docume... (2)
-> + unable to create any xquery (3)
-> + counter in xquery (5)
-> + How to change JVM settings -Xm... (4)
-> + Postgresql (3)
-> + Can I call an xquery file from... (5)
-> + How to output a text with a mi... (3)
-> + Mapping - How Include the Sche... (6)
-> + XQuery beginner problem (2)
-> + No output from StylusFile Conv... (3)
-> + getting all nodes leading up t... (3)
-> + Java exception when apply regu... (5)
-> + X12 resources not reachable (T... (13)
-> + XQuery error on Oracle views (5)
-> + Results multiplied by number o... (3)
-> - Continous sequence check (1)
-> + No results for second row of s... (14)
-> + Problems connecting to DB2/400... (6)
-> + External Class : Invalid linki... (8)
-> + Error during SQL execution: [O... (2)
-> + Warnings when running Schema a... (2)
-> + XQuery basics (2)
-> + XPath Query Editor - not visib... (3)
-> + Document loading and unloading (3)
-> + Xpath to return xmlns (3)
-> + How to execute xQuery and exec... (3)
-> + Schema Aware Saxon (5)
-> + Want to execute a XQuery by AP... (7)
-> + Use a user-defined adapter as ... (2)
-> + RDB collections versus DB-to-X... (5)
-> + XMLTABLE WITH COLUMN OF ALL NO... (5)
-> + Xquery question (4)
-> - XQuery 1.0 is now a Proposed R... (1)
-> + I can't seem to get my xml "re... (7)
-> + Custom pipeline elements (4)
-> + FIND ALL ELEMENTS WITH SAME NA... (3)
-> - CONCATENATE COMPLEX TYPE ELEME... (1)
-> + XQuery & MySQL (4)
-> - Referring elements from an imp... (1)
-> + Selecting operator from XML to... (5)
-> + copy-namespaces mode (5)
-> + XQuery and Javascript 1.5+ on ... (2)
-> + XQuery sort & extract data (4)
-> + [DataDirect][XQuery]No value h... (9)
-> + About typing system for XQuery... (5)
-> + root() vs // - saxon and built... (3)
-> + XQuery or XPath "between" func... (4)
-> + Xpath Query Editor button grey... (3)
-> + Processing Instructions, Built... (4)
-> + XPath parser in Java (3)
-> + XQuery "declare xmlspace prese... (10)
-> + Save results of XQuery as CSV? (7)
-> + Cleanup and combine question (3)
-> + xquery function from within xs... (4)
-> + Saxon XQuery error (4)
-> + xquery and 1gb xml files (3)
-> + How can i output key words suc... (5)
-> + Viewing XQuery (4)
-> - Webinar: Using XQuery and Data... (1)
-> + Java code generated by Xquery ... (6)
-> + Multiple items in return (2)
-> + Confused using match (2)
-> + Counting distinct node types (7)
-> + XQUERY Newbie question (3)
-> + Receiving a function as a para... (7)
-> + Xpath Version - and Doc for Re... (2)
-> + Convert namespace? (2)
-> + Can I search for one line and ... (3)
-> + Reading Data from Soap Respons... (2)
-> + Access To XML Query Question (4)
-> + Xquery find avg and count (3)
-> + Bug using global variables in ... (3)
-> - Problem uploading XSLT to xml ... (1)
-> + Bug? HTMLTidy does not support... (2)
-> + Finding a string within an XML... (4)
-> + Store query result in java.lan... (2)
-> + Comparing databases and XML. (3)
-> + namespace information with XQu... (4)
-> + Single row to multiple row tra... (3)
-> + Webservice call failed (2)
-> + Stylus Studio has encountered ... (2)
-> + My XQUERY on Berkley DBXML s... (2)
-> + Filtering multiple values from... (5)
-> + SaxonB8.4 testing (8)
-> + Problem with oracle large tabl... (3)
-> + incorrect syntax? (3)
-> + XQUERY-based app usage (4)
-> + position() and last() in XQuer... (3)
-> + Returning Values (5)
-> + new to XQuery- "expected cardi... (2)
-> + using XQuery to keep all data ... (2)
-> + search in XQuery (6)
-> + Defined source and destination... (2)
-> + Stopping running xquery in R2 (4)
-> + XQuery where can i use it? (5)
-> + Scheduling the conversion (2)
-> + Converting Oracle table to XML... (5)
-> - Formating and Indentation Pres... (1)
-> + Omiting the XML declaration fr... (4)
-> + Define function (4)
-> + External Java class problems (15)
-> + C++/COM API for XQuery (3)
-> + PROBLEM AT THE DECLARATION OF ... (3)
-> - Cobol Flat file to XML (1)
-> + xpath question (2)
-> + XQST0059 cannot locate the req... (6)
-> + How to generate XML with proce... (2)
-> + ODBC Connection refused (12)
-> + node search and replace (3)
-> + generate xml file on web serve... (5)
-> + How to navigate to a ref node (5)
-> + How to query when a default na... (2)
-> + full xpath to a node (3)
-> + Performance bench (2)
-> + how to run xquery using java (2)
-> + [ convert dtd to xsd ] (3)
-> + How to map a recursive node? (9)
-> + java class implementing extern... (3)
-> + context to context reference (2)
-> + Problems with Replace (7)
-> + Use of special characters in X... (5)
-> + How to write XML Parser IN VC+... (2)
-> + Xquery (5)
-> + Trivial XQUERY application que... (2)
-> + XML as a data model (2)
-> + XQuery (2)
-> + Relative path (2)
-> + Support for xml is-idref (4)
-> + Accessing the document context... (3)
-> + Getting recursion return type ... (4)
-> + Parsing XMLFormatted as String... (5)
-> + XQuery Replace (2)
-> - How to join the two table usin... (1)
-> + Update variable value inside b... (5)
-> + Run XQuery on XMLDB databases (2)
-> + Treatment of reserved characte... (6)
-> + XQuery Core (6)
-> + Built-In Saxon 8.4 processor (3)
-> + dynamic order by clause (3)
-> + Dynamical xpath (3)
-> + How to use xquery? :) (2)
-> + Converting SQL query to XQuery (4)
-> - New XQuery Primer: Learn XQuer... (1)
-> - XQuery Co-Author and XML Indus... (1)
-> + sequence to collect (3)
-> + user defined functions in xque... (2)
-> + Need second set of eyes to deb... (2)
-> - Xquery calling Java function f... (1)
-> + Xquery on existing XML files i... (2)
-> + Need Help Resorting (11)
-> + "for" clause question (2)
-> + New XQuery Video: Using DataDi... (2)
-> + data() function not returning... (2)
-> + XSL-FO using RenderX's XEP on ... (4)
-> + Xquery to find sample data fil... (4)
-> + Xquery to find sample data fil... (4)
-> + Error with Berkeley XML DB and... (13)
-> + Berkeley XML DB & Professional... (3)
-> + question (2)
-> + Writing UDDI API's in XQuery (2)
-> - DataDirect XQuery Enables XQue... (1)
-> + Xquery to MS/SQL? (8)
-> + Left Outer Join in XQuery (2)
-> - New XQJ Tutorial and Example F... (1)
-> + asked (2)
-> - generate XML file from tables ... (1)
-> - XQuery interest growing: DevX (1)
-> + New to XQuery question (2)
-> - Help Support XQuery in the Mic... (1)
-> + Xquery and Web Service Caller (4)
-> + XQuery from JavaScript? (4)
-> + Find Maximum Numeric Value in ... (2)
-> + Can you use XQuery and SQL/XML... (2)
-> + XQuery and Relational Data map... (2)
-> + STyluus and C# (MS) (2)
-> - XQuery making headlines (again... (1)
-> + XQuery Syntax (2)
-> - XQuery in Outer Space (1)
-> + import several modules in a xq... (2)
-> - Developers Flock to XQuery Spe... (1)
-> + UPDATE (2)
-> + global variable (4)
-> - XQuery on all XML Files in a D... (12)
-> ->XQuery on all XML Files i...
-> ->XQuery on all XML Files i...
-> ->XQuery on all XML Files i...
-> ->XQuery on all XML Files i...
-> ->XQuery on all XML Files i...
-> ->XQuery on all XML Files i...
-> ->XQuery on all XML Files i...
-> ->XQuery on all XML Files i...
-> ->XQuery on all XML Files i...
-> ->XQuery on all XML Files i...
-> ->XQuery on all XML Files i...
-> + Stylus Studio Interoperability... (5)
-> - Genereating values in a combob... (1)
-> - SQL Server 2005 "Yukon" (1)
-> - XQuery Drivers (1)
-> - Database Trends and Applicatio... (1)
-> - Why XQuery? How new XML Standa... (1)
-> - Develop, Edit and Debug XQuery... (1)
-> + Native XML Database Tools (3)
-> - XQuery in Bank Systems and Tec... (1)
-> + User functions (5)
-> + Setting Values for External Va... (4)
-> - XQuery 2005 Road Show (1)
-> - XQuery Introduction (1)
-> - New XQuery Developer Awards Pr... (1)
-> + Convert String to xml document... (2)
-> + import de modules (7)
-> + String to XML conversion in a ... (2)
-> + DML language (2)
-> + Newbie Xquery problem to solve (7)
-> - What is XQuery? (1)
-> - XQuery Talk: Priscilla Walmsle... (1)
-> + Learn XQJ : The XQuery API for... (3)
-> + XQuery to consolidate modular ... (6)
-> + problem with xquery (4)
-> + use cases (5)
-> - XQuery and XQJ Talk with Jason... (1)
-> + append the output of the xquer... (3)
-> + Problem with command line argu... (4)
-> - Can you associate hundreds of ... (1)
-> + PARAMETER VALUES IN STYLUS STU... (2)
-> + Problem with stylusxql calls (5)
-> - Join us for Eggs & XML at the ... (1)
-> + More about Java extensions and... (2)
-> + Stylus Studio Crashes with Jav... (6)
-> - An Interview with Jason Hunter... (1)
-> + attribute order in query resul... (3)
-> - Interview with XQuery Guru Dr.... (1)
-> + SequenceType matching failed" ... (2)
-> + XQuery tutorial (3)
-> - W3C Releases Public Working Dr... (1)
-> + Problem with a function (3)
-> + Problem with Stylus Studio 5.3 (5)
-> + Studio Studio crashes (7)
-> + STYLUSXQL (8)
-> + Execute a Query From the Comma... (2)
-> + Import Modules. (8)
-> + User-Defined Functions (3)
-> + new to Xquery (3)
-> + XQuery engines (4)
-> + APIs or OCXs (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Neal WaltersSubject: XQuery on all XML Files in a Directory?
Author: Neal Walters
Date: 11 Mar 2005 03:23 PM
Does XQuery have any support to read all files in a directory
(or a mask such as ABC*.xml)
and "peel off" one or two XML elements from each file?

So for example, I have a directory with 300 XML orders in it.
I want to create a unique list of credit card types, or create
a single XML file that contains for example order number
and order amount (for all orders in that directory).

Thanks in advance,
Neal Walters
http://XML-Online-Training.com
http://Biztalk-Training.com
http://VBScript-Training.com

Postnext
Ivan PedruzziSubject: XQuery on all XML Files in a Directory?
Author: Ivan Pedruzzi
Date: 14 Mar 2005 11:25 AM
Neal



XQuery doesn't expose direct access to file system.

There are differen approach to solve the problem:


1) define an external variable and let caller fill it with
a sequence of strings that represent the file paths

2) Assuming the file have some name + postfix index like
books001.xml, books002.xml, etc you could write

for $row in 1 to 4
return doc(concat('books00', xs:string($row), '.xml'))

3) use an extension function; here a quick example that concatenates
all .xml files in the simpleMappings directory

---------------------------------------------
FileUtils.java

import java.net.*;
import java.io.*;

public class FileUtils
{
public static String listFiles(String root) throws URISyntaxException
{
File f = new File(new URI(root));
String[] list = f.list();
StringBuffer sb = new StringBuffer();
for(int i = 0; i < list.length ; i++){
if(sb.length()>0)
sb.append(",");
sb.append(list[i]);
}
return sb.toString();
}
}

---------------------------------
FileDir.xquery

declare namespace ext = "FileUtils";
declare function ext:listFiles($path as xs:string) as xs:string* external;
declare variable $root as xs:string := "file:///c:/Program%20Files/Stylus%20Studio%20XML%20Professional%20Edition/examples/simpleMappings";
<root>
{
for $file in fn:tokenize(ext:listFiles($root), ",")[fn:matches(., ".xml")]
return
<file>{doc(fn:concat($root, "/", $file)) } </file>
}
</root>

Hope this helps
Ivan
Postnext
Neal WaltersSubject: XQuery on all XML Files in a Directory?
Author: Neal Walters
Date: 14 Mar 2005 12:25 PM
Very cool!

Do external functions only work with Java?
We are more of a Microsoft shop.
What about VB/Script and/or .NET?

Thanks,
Neal Walters

Postnext
Ivan PedruzziSubject: XQuery on all XML Files in a Directory?
Author: Ivan Pedruzzi
Date: 14 Mar 2005 10:37 PM

Neal,

Unfortunately Microsoft is not going to ship XQuery API (client side) in the upcoming .NET Framework :(
So I can't suggest an XQuery solution but...

If you are willing to use XSLT (and the .NET processor) you could try this


<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:u="urn:my-scripts"
exclude-result-prefixes="u msxsl">

<xsl:output method="text"/>

<xsl:param name="root" select="'c:\Program Files\Stylus Studio XML Professional Edition\examples\simpleMappings'"/>

<msxsl:script language="C#" implements-prefix="u"><![CDATA[
public string Dir(string path, string pattern)
{
StringBuilder sb = new StringBuilder();
foreach (String s in System.IO.Directory.GetFiles(path, pattern)){
if( sb.Length>0)
sb.Append(",");
sb.Append(s);
}
return sb.ToString();
}

public int FilesCount(String files)
{
return files.Split(',').Length;
}

public string GetFile(String files, int pos)
{
return files.Split(',')[pos];
}
]]>
</msxsl:script>

<xsl:template match="/">
<xsl:variable name="files" select="u:Dir($root, '*.xml')"/>
<xsl:call-template name="listFiles">
<xsl:with-param name="files" select="$files"/>
<xsl:with-param name="index" select="u:FilesCount($files)-1"/>
</xsl:call-template>
</xsl:template>

<xsl:template name="listFiles">
<xsl:param name="files"/>
<xsl:param name="index"/>

<xsl:value-of select="u:GetFile($files, $index)"/><xsl:text>
</xsl:text>
<xsl:if test="$index > 0">
<xsl:call-template name="listFiles">
<xsl:with-param name="files" select="$files"/>
<xsl:with-param name="index" select="$index - 1"/>
</xsl:call-template>
</xsl:if>
</xsl:template>

</xsl:stylesheet>


Hope this helps
Ivan

Postnext
Neal WaltersSubject: XQuery on all XML Files in a Directory?
Author: Neal Walters
Date: 15 Mar 2005 02:24 PM
I really want to use Xquery, not XSLT for it's join features.

Although I'm a SCJP (Sun Cert. Java Programmer),
I haven't used Java much in about 2 years.
I just spent an hour or two reinstalling the SDK on my laptop which
I have had for almost a year without touching Java.
I would like to share this XQuery with other people, but I the Java
install might be a "kill-joy".

I kind of like your "external variable" idea.
I hope to play with that later. I could run a VBScript
which could build the value of the external variable, then
copy/paste that value. The only problem is that this would be
a manual step that would have to be done any time new files are
added to the directory (and if the directory had 2 or 3 thousand
files in it, that would be a rather large variable value).

Here's some variations of your code that I are working for me:

declare namespace ext = "FileUtils";
declare function ext:listFiles($path as xs:string) as xs:string* external;
declare variable $dirname as xs:string := "file:///c:/Documents%20and%20Settings/nwalters/My%20Documents/Altura/TestDir/";
<root>
{
for $filename in fn:tokenize(ext:listFiles($dirname), ",")
[fn:matches(., ".xml")]
return
<filename>{$filename}</filename>
}
</root>

The above works fine, and displays the filenames.
Your code also worked which displayed the entire doc.
I did change some of your names to make more sense to me.

Below is a fancier version that I then created to
pick off the XML elements/attributes that I was interested
in showing.

declare namespace ext = "FileUtils";
declare function ext:listFiles($path as xs:string) as xs:string* external;
declare variable $dirname as xs:string := "file:///c:/Documents%20and%20Settings/nwalters/My%20Documents/Altura/TestDir/";
<OrderReport>
{
for $filename in fn:tokenize(ext:listFiles($dirname), ",")
[fn:matches(., ".xml")]
, $rootel in doc(fn:concat($dirname, "/", $filename))/CC_TRANSMISSION
return
<filename name='{$filename}'>
<orderNo>{$rootel/CC_ORDER/@ORDER_NO/text()}</orderNo>
<orderAmt>{$rootel/CC_ORDER/TOTALS/TL_TOTAL/text()}</orderAmt>
</filename>
}
</OrderReport>

One of the "gotchas" was that the dirname value must have the %20
instead of blanks. I copied a filename from another place on
Windows, and started getting strange errors.

Thanks so much for getting me started with this!

Neal Walters
http://Biztalk-Training.com
http://XML-Online-Training.com
http://VBScript-Training.com




Postnext
Neal WaltersSubject: XQuery on all XML Files in a Directory?
Author: Neal Walters
Date: 01 Aug 2006 05:27 PM
Hi Ivan,

It's over a year later - and I'm trying this type of code again at another client.

I have found that if the filenames contains braces such as this:
{003D81D1-39CA-4A85-9C63-F5570E9EAA29}.xml
then I get the following error:
Invalid argument to fn:doc function [err: FODC0005]

So is there a replace or something I can do in the Xquery code that will switch left curly to it's hex equivalent? Would that work?

Thanks,
Neal

Postnext
Ivan PedruzziSubject: XQuery on all XML Files in a Directory?
Author: Ivan Pedruzzi
Date: 01 Aug 2006 06:01 PM

Hello Neal,

On which XQuery processor are you planning to deploy?

If you need to execute the query in the IDE you can use Saxon.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Postnext
Neal WaltersSubject: XQuery on all XML Files in a Directory?
Author: Neal Walters
Date: 01 Aug 2006 06:21 PM
I'm running in the IDE - just a one-time job or a model for future jobs that developers will run (will not go to production).

I was using Built-In, but just now tried switching to Saxon, but then it has trouble with the Java FileUtils.
Error on line 2 column 66 of file:///c:/myquery.xquery
XPST0003:XQuery syntax error in #...tring) as xs:string* exteranl;#;
Saxon does not allow external functions to be declared.

Also, where can one quickly find a list of all the available functions in Xquery (which are the same as XSLT and Xpath, correct?). Is there a function section in Stylus Studio help, or do I need to look elsewhere.
I have gone to Stylus Studio Doc, Search, fn:Concat for example, and do not find anything.






Postnext
Ivan PedruzziSubject: XQuery on all XML Files in a Directory?
Author: Ivan Pedruzzi
Date: 01 Aug 2006 06:53 PM

Saxon uses a different syntax to bind extension functions

declare namespace fu = "java:FileUtils";
fu:listFiles("file:///c:/temp")


XQuery 1.0 and XPath 2.0 Functions and Operators can be found here
http://www.w3.org/TR/xpath-functions/

if you type in the XQuery editor the letter c you should see the suggestion list, once you select "concat" you get tool-tip prototype

Because concat is also XPath 1.0 is documented in the Stylus Studio online help. See "XPath Functions Quick Reference" or search concat.


Ivan Pedruzzi
Stylus Studio Team

Postnext
Tony LavinioSubject: XQuery on all XML Files in a Directory?
Author: Tony Lavinio
Date: 02 Aug 2006 11:10 AM
If the question is 'how do I escape the special-purpose { and }
characters in XQuery?', then try doubling them.

See the second-to-last paragraph under section 3.7.1
http://www.w3.org/TR/xquery/#id-element-constructor

Postnext
Ivan PedruzziSubject: XQuery on all XML Files in a Directory?
Author: Ivan Pedruzzi
Date: 02 Aug 2006 12:29 PM
Hi Neal,

The doc function takes as argument a URL. If you want to be sure to run on any XQuery implementetations use fn:encode-for-uri to generate a valid URL.

http://www.w3.org/TR/xpath-functions/#func-encode-for-uri

doc(fn:encode-for-uri("{003D81D1-39CA-4A85-9C63-F5570E9EAA29}.xml"))

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Posttop
Neal WaltersSubject: XQuery on all XML Files in a Directory?
Author: Neal Walters
Date: 02 Aug 2006 03:29 PM
Thanks again for the tip. Here's how I used it:

declare namespace ext = "FileUtils";
declare function ext:listFiles($path as xs:string) as xs:string* external;
declare variable $dirname as xs:string := "file:///c:/xmltest";

<Sample>
{
for $filename in fn:tokenize(ext:listFiles($dirname), ",")
[fn:matches(., ".xml")]
, $rootel in doc(fn:concat($dirname, "/", fn:encode-for-uri($filename)))
return
<filename name='{$filename}'>
<root>{$rootel//*[local-name()='AdminError']/*[local-name()='CorrelationId'][1]}</root>
</filename>
}
</Sample>
   
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.