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 General Question
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)
-> ->XQuery General Question
-> ->XQuery General Question
-> ->XQuery General Question
-> ->XQuery General Question
-> ->XQuery General Question
-> ->XQuery General Question
-> ->XQuery General Question
-> ->XQuery General Question
-> ->XQuery General Question
-> ->XQuery General Question
-> + 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)
-> + 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
Mike JordanSubject: XQuery General Question
Author: Mike Jordan
Date: 27 Dec 2008 08:57 PM

I'm on the evaluation period of Stylus Studio 2008 and I've been trying to determine if it will do what I need to do easier than using Visual Studio, which I already have a license for.

What I'm trying to do is extract information out of a lot of 2 meg size XML files that are generated each day during our call center activity. I want to search each file for specific information and write that to another file if it finds it.

When I read about XQuery, it sounded a lot easier that continuing to work with Visual Studio C# to do the same thing. I'm at about the same point with both programs... I can open a single XML file and find an occurance of what I'm looking for. XQuery actually gives me all the data in the section where the error message is that I'm looking for. This is good. The problem is that it's taken me 3 weeks of researching XPath coding to get this (we were having the worst snow storm in 40 years in the Pacific Northwest during this time, so I wasn't able to spend a lot of time working on it) far.

Looking over some of the messages in the forum, it looks like I'm still going to have to learn a bunch of programming to get what I'm after. And I see mention of something called Saxon to do some of the things I want, which I don't know if that is part of Stylus Studio or if it's another program that I would have to buy to work with Stylus Studio.

The marketing information on the web site makes it sound real easy to extract information from XML files, but so far, I'm not finding it to be all that easy. I've gone through a couple of tutorials and they didn't really give me enough information to get very far. So I'm beginning to think that since I already own Visual Studio, that I'm not going to gain anything by buying a license for Stylus Studio as I'm still going to have to do a bunch of coding to extract the data... which I'm going to have to learn first.

It's possible that I'm missing something in XQuery and trying to do this the hard way. It wouldn't be the first time I've done that. So rather than just delete it after my demo period is up (or sooner since I keep getting frustrated with it), I thought I'd ask to see what sources I'm missing that could help me see that it will make it easier to extract information out of my XML files.

Thanks

Mike
Postnext
Minollo I.Subject: XQuery General Question
Author: Minollo I.
Date: 27 Dec 2008 10:54 PM
XQuery is a programming language; as for any programming language, there is a learning curve. Is it worth it? Based on the problem you are trying to solve, I would say yes; once you have passed the initial learning period, the power and flexibility that XQuery provides you when querying and creating XML is impressive; no comparison with other languages like C#, C++ or VB (or Java) that you may be considering.

Stylus Studio bundles two XQuery engines: DataDirect XQuery (www.xquery.com), which is owned by the same company that develops Stylus Studio (www.datadirect.com); and Saxon (www.saxonica.com), which is an XQuery engine available as open source and as a commercial product. DataDirect XQuery specializes in performance, scalability and RDBMS access; you can find plenty of information on its web site (www.xquery.com) and on its blog (www.xml-connection.com).
Stylus Studio itself is a development environment; you can run both DataDirect XQuery and Saxon from within Stylus Studio, and if you want to run XQuery out of the Stylus Studio context you will need to acquire "runtime" licenses for the XQuery engine.

If you would like some help about how to query your multiple documents and create the required output, feel free to post here some sample data and sample results, and we'll do our best to make things easier for you. If you need an extension to your Stylus Studio evaluation, let us know, and we'll take care of that too.
Postnext
Mike JordanSubject: XQuery General Question
Author: Mike Jordan
Date: 28 Dec 2008 01:33 AM
Originally Posted: 28 Dec 2008 01:31 AM
Minollo, thanks for the fast reply. There is usually a learning curve in everything, sometimes I have problems getting the traction to make it up the curve. The one problem I've been having is finding a beginning of where to start. I've gone through your tutorials and online help and even the one it says you can learn it in 10 minutes. I think I need more than 10 minutes. :D

I would normally have one of my programmers do this, but they are both busy on more important and bigger projects, and I'm getting tired of waiting, so I've been trying to do it myself.

What I have is a bunch of trace logs that are written to by our call center application until they reach 2 megs in size. Then it is closed and another one is started. During a 24 hour period we can get 30 or more of these files created. What I want to do is run a program that will look at each file and look for a event message and if it occurs to write out about 7 or so elements of the 28 in that section. If it's easier to just pull out the whole 28 elements and their text, that's ok too.

This is one of the sections that my query is pulling out now:

<DropEvent>
<SocketId/>
<SessionId/>
<UserName>User6116</UserName>
* <Station>5707</Station>
<ActiveCRV>2316</ActiveCRV>
<MsgCtrlId>9969801 2008-07-17 12:40:19</MsgCtrlId>
<ANIMatch>N</ANIMatch>
<CustId/>
<CPN>2062743020</CPN>
<GPDirSignOn>N</GPDirSignOn>
<SignOnFlag>Y</SignOnFlag>
* <GPowerCallId>4636100</GPowerCallId>
<ActiveCallId>537</ActiveCallId>
<PartyType>Agent</PartyType>
<EndingNum>5707</EndingNum>
* <AgentId>6210</AgentId>
* <AgentName>Cheryl</AgentName>
* <OrigDateTime>2008-07-17 12:40:02</OrigDateTime>
<CallDuration>1</CallDuration>
<TrackingPhone/>
<TrackingId/>
<TrackingName/>
<TrunkGroup>5</TrunkGroup>
<TrunkNum>6</TrunkNum>
<Source>RedirectedEvent RedirectedEvent</Source>
<CountryCode/>
<CityCode/>
<GPServerDateTime>2008-07-17 12:40:19</GPServerDateTime>
</DropEvent>

The lines with the * in front are the ones I'd like to pull out if that is possible. I looked through some of the XPath coding and didn't see a way to specify just certain elements.

My query that I did to extract the above looks like this:

TraceFile/TraceRec/Message/DropEvent[Source="RedirectedEvent RedirectedEvent"]

I created a project and assigned the Test1.xml file to the query as I didn't even know how to tell the query itself to use a specific file. This has been the frustrating part so far, trying to figure out how to create a simple query that you tell where the .xml file is, which one to read in, what to look for and what to do with the output. That's why I kept going back to C# as I'd been able to do that part already. But you are right, XQuery does look like it would be much easier to create with if I get up the learning curve a bit. I'm sure what I'm trying to do is about as basic as it gets for XQuery too and I'm just trying to make it harder than it needs to be. :D

So if you can get me started, I would appreciate it. And I might need an extension on the trial period, but I still have a few more days available, I think.

Thanks

Mike
Postnext
Minollo I.Subject: XQuery General Question
Author: Minollo I.
Date: 28 Dec 2008 04:24 PM
If you were working with a single file, you could do something like this (assuming my log file is in c:\a):
<myEvents> {
for $event in doc("file:///c:/a/log1.xml")//DropEvent
where $event/Source="RedirectedEvent RedirectedEvent"
return
<event> {
$event/Station,
$event/GPowerCallId,
$event/AgentId,
$event/AgentName,
$event/OrigDateTime
} </event>
} </myEvents>

Working with a collection of log files, you can do something like this (assuming the log files are in c:\a and named log*.xml):
<myEvents> {
for $event in collection("file:///c:/a?select=log*.xml")//DropEvent
where $event/Source="RedirectedEvent RedirectedEvent"
return
<event> {
$event/Station,
$event/GPowerCallId,
$event/AgentId,
$event/AgentName,
$event/OrigDateTime
} </event>
} </myEvents>

Helps?
Postnext
Mike JordanSubject: XQuery General Question
Author: Mike Jordan
Date: 28 Dec 2008 06:09 PM
It helps right off the bat as it shows me how to even find the file I want to open. I tried putting a line with DOC using DOC(file:///C:/text.xml) and several other different ways and kept getting an error message.

I'll give this a try and let you know. Thanks.

Mike
Postnext
Mike JordanSubject: XQuery General Question
Author: Mike Jordan
Date: 28 Dec 2008 06:34 PM
Well, I found out another thing I was not considering... it seems that at least file names are case sensitive. Most of the programming I've done over the last 5 years or so has been in SQL queries and it doesn't care about case, so I'm use to just doing everything in mostly lowercase. My file names are both upper and lower case and because I didn't have my filename* at the correct case, it didn't work at first. I thought it didn't like spaces in the path names at first, but that wasn't the problem at all.

It looks good so far. And the example you gave makes sense and provides some of the information I was looking for to get started.

I have another question. Is the syntax that you used the XQuery language that is in the book XPath 2.0 Programmers Reference by Dr. Michael Kay that is on your website?

Thanks

Mike
Postnext
Minollo I.Subject: XQuery General Question
Author: Minollo I.
Date: 28 Dec 2008 08:11 PM
Originally Posted: 28 Dec 2008 08:10 PM
The example I've included is an XQuery example, consistent with the XQuery 1.0 language specified by the W3C (http://www.w3.org/XML/Query/); both DataDirect XQuery and Saxon will run it.

XPath 2.0 is the expression language used by XQuery (and XSLT 2.0); you can think of XQuery as a super-set of XPath 2.0. See http://www.xml-connection.com/2007/09/xquery-book-recommendation.html for additional recommendations in terms of XQuery publications; you may also find more useful examples in the blog.
Postnext
Mike JordanSubject: XQuery General Question
Author: Mike Jordan
Date: 28 Dec 2008 08:48 PM

I'll go browse though that information, thanks.

I have another question about Stylus Studio and usage. If I have a licensed copy of Stylus Studio and create different queries for people to run against our various xml files, does each person need to have Stylus Studio installed and a license? In other words, if they are just going to be running the query but not developing, does everyone have to have a copy of Stylus Studio? Or is there a run time version?

Thanks for all the help, Minollo. With your help, it looks like I'm going to have enough to show why this is a good program to buy. :D

Mike
Postnext
Minollo I.Subject: XQuery General Question
Author: Minollo I.
Date: 29 Dec 2008 06:05 PM
The recommended "runtime license" is DataDirect XQuery (http://www.xquery.com), which can be executed through a command line, integrated in a Java application or even accessed as a Web service hosted by your preferred app server.

Postnext
Mike JordanSubject: XQuery General Question
Author: Mike Jordan
Date: 04 Jan 2009 10:47 AM
Hi Minollo, I just wanted to follow up and let you know I am going to purchase a copy. My company vendor, Insight, has been trying to get updated pricing and part numbers but it seems your sales person was not available last week. I still haven't decided which version to go with, Professional or Enterprise yet, as I'm not sure if I will ever get to the point that the extra features of Enterprise will be useful.

I also checked on DataDirect XQuery. There was no pricing on their web site (that I could find) to indicate it's price and my sales rep at Insight is trying to find that out as well.

I still have lots of questions, but you have shown me enough to know that I can do what I want with this program... once I get past the learning curve.

Thanks for your help and I know I'll be back with more questions.

Mike
Posttop
Minollo I.Subject: XQuery General Question
Author: Minollo I.
Date: 04 Jan 2009 11:00 AM
Sorry for the trouble in talking to our sales reps. I'm sure tomorrow someone will get in touch with your vendor.
   
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.