XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Hrithik RoshanSubject: Stylus Studio XML generation from relational database
Author: Hrithik Roshan
Date: 30 Jul 2007 04:59 PM

We are a company that gets orders through the web. When someone orders, it is updated in the database and we generate an XML of that order and FTP the XML to the lab for printing.

Is it possible for stylus studio, whenever an order is placed(or an update is made to the database), to detect that update and generate an XML for that particular update.

Alberto MassariSubject: Stylus Studio XML generation from relational database
Author: Alberto Massari
Date: 31 Jul 2007 04:42 AM
Stylus Studio doesn't support monitoring a database table or a file repository to detect incoming messages; but you can implement what you need by directly using DataDirect XQuery 3.0, especially if the message is delivered through a Web Service.
In this case you could implement the Web Service through an XQuery program (see http://www.xquery.com/examples/web-service-example); the XQuery would generate the XML fragment and at the same time update the database table using the SQL extension functions of DataDirect XQuery (see http://www.xquery.com/examples/updates).

Hope this helps,

Go to previous topicPrev TopicGo to next topicNext Topic
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!  

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.