# Tuesday, 31 May 2016
Check out the latest video from the Stylus Studio Team:

Tutorial: Tab Separated Data to XML with Grouping

posted on Tuesday, 31 May 2016 14:50:12 (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Wednesday, 25 May 2016
Stylus Studio X16 is Here

Stylus Studio X16 Is Now Available!

It's one of our biggest releases ever! X16 includes support for the latest multicore hardware, 64-bit support, a new SQL Editor, a new, powerful Generic Converter, support for the latest Saxon release and more.

64-bit Power

Stylus Studio X16 brings the muscle. Built for the latest multicore technology and featuring 64-bit support, X16 handles massive files and delivers powerful processing.

Download Now

New SQL Editor

X16's new SQL Editor features SQL syntax recognition and coloring, a scalable grid and database schema tree, and bult-in connectivity to Microsoft SQL Server, oracle, MySQL, and DB2.

Download Now

Buy Stylus Studio X16 Today

Get the latest and greatest Stylus Studio right now at the same fantastic prices. Stylus Studio Enterprise Suite and Professional Suite come packed with developer tools and features to give you the ultimate value.

Buy Now

Unsubscribe Here

Copyright © 2016 IVI Technologies Inc. All Rights Reserved.

This message was sent because you have expressed interest in Stylus Studio through the Stylus Studio website. In accordance with our Privacy Policy, if you would prefer not to receive further notifications or email communications of this type, please go to the following web page and update your subscription profile, or contact us through postal mail at: IVI Technologies Inc., c/o Stylus Studio Consumer Affairs Office, 8672 SW 40 Street, Suite 206, Miami, FL,33155, USA.

View the trademarks, service marks, or registered trademarks of DataDirect Technologies in the U.S. and other countries. Any other trademarks or service marks contained herein are the property of their respective owners. All rights reserved.

posted on Wednesday, 25 May 2016 09:57:21 (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Saturday, 23 April 2016

Some time you may need to wrap text node in a CDATA section as part of your XQuery development. For example say you need to generate the following document

<?xml version="1.0" encoding="UTF-8"?>
<sf:Resource xmlns:sf="http://www.canadapost.ca/smartflow" contentID="PAYMENT">
            <total-due>bar</total-due>             <due-date>bar</due-date>         </payment-data> ]]></sf:Resource>

The following query makes use of a processor specific XQuery option called ddtek:serialize 

Notice the syntax to define an expanded QName with namespace is { {uri} local-name }  which is different from what is erroneously described in the XQuery Tips & Tricks 

The second takeaway is how the content inside sf:Resource needs to be escaped text to produce the required result

declare namespace sf="http://www.canadapost.ca/smartflow";
declare option ddtek:serialize "omit-xml-declaration=no,encoding=UTF-8,indent=yes,cdata-section-elements={{http://www.canadapost.ca/smartflow}Resource}";
declare variable $foo := "bar";
<sf:Resource contentID="PAYMENT">
       &lt;account-number&gt;{ $foo }&lt;/account-number&gt;
       &lt;total-due&gt;{ $foo }&lt;/total-due&gt;
       &lt;due-date&gt;{ $foo }&lt;/due-date&gt;

Multiple CDATA sections are declared using ; as separator


posted on Saturday, 23 April 2016 17:58:32 (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback