Working with Query Results

Query results are shown in the XPath Query Editor in the results pane as a number of hits and include the type of XML tag and value of each hit, as shown here.

Figure 285. XPath Result Pane

When you click on a result node, Stylus Studio's back-mapping feature highlights the line in the XML document that supplied the value for the result node you selected.

Opening Query Results as a New Document

After you have executed a query, you can optionally choose to display the query result in a new XML document. If the result contains only elements, Stylus Studio creates a root element (named < xqr:xpath-query-result>) to ensure that the document is well-formed.

To open a query result as an XML document:

Execute the query, and then

  • Click the Open result in a new XML document button on the XPath Query Editor tool bar ( ).

Alternative:

  • Right-click the query pane in the XPath Query Editor and select Open result in a new XML document from the shortcut menu.

Database-to-XML Mapping

Stylus Studio features several database-to-XML mapping tools that allow you to easily query a relational database using SQL/XML or SQL and render the results as XML. Stylus Studio also supports the world's first and only visual SQL/XML Editor!

Using Stylus Studio's Database-to-XML Editor to Query and Update Relational Databases using SQL/XML

Watch and learn how easy it is to define relational-to-XML mappings for getting XML out of relational databases and updating databases from XML using industry-standard SQL/XML extensions and Stylus Studio's DB-to-XML data-source editor.

XML Schema Quality Checker

Use IBM's alphaWorks XML Schema Quality Checker to check the quality and style of your XML schema documents. Fully integrated with the Stylus Studio XML Schema Editor and XML validator.

Stylus Most Wanted

 
Free Stylus Studio XML Training:
W3C Member