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
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)
- Stylus Studio FAQs (159)
-> + Use XSD to produce sample XML... (2)
-> + Port to MAC OS X (2)
-> + First-time running froze! :( (2)
-> + how to register stylus studio ... (5)
-> + Wrapped Lines (3)
-> + CSV to XML Conversion (2)
-> + Xquery ques. How to check for ... (2)
-> + XQUERY default views (3)
-> + DB to XML Data Conversion issu... (2)
-> - Rendering XForms with XSLT-sty... (1)
-> + Multiple XSDs to XML (2)
-> + Tables in WISIWYG (2)
-> - Does Stylus Studio provide API... (2)
-> ->Re: Does Stylus Studio pr...
-> + xlink (2)
-> + Tags in WYSIWYG (2)
-> + Removing spaces from XSLT Sour... (2)
-> + SS capabilities (3)
-> + Stylus Studio 3.1 in Windows X... (2)
-> + Macros and API (2)
-> + Stylus Studio FO support (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Nestor BucoskySubject: Does Stylus Studio provide API for ADO Wizard
Author: Nestor Bucosky
Date: 14 Apr 2003 03:19 PM
I would like to use the functionality that is provided by the "XML from ADO" wizard in a "batch" mode for the purposes of automation.

Does Stylus Studio provide an API or a hook that I can use to invoke this functionality ?

thanks

Nestor

Posttop
(Deleted User) Subject: Re: Does Stylus Studio provide API for ADO Wizard
Author: (Deleted User)
Date: 14 Apr 2003 03:46 PM
Hi Nestor,

At 15.39 14/04/2003 -0400, you wrote:
>From: "Nestor Bucosky"
>
>I would like to use the functionality that is provided by the "XML from
>ADO" wizard in a "batch" mode for the purposes of automation.
>
>Does Stylus Studio provide an API or a hook that I can use to invoke this
>functionality ?

Stylus doesn't provide a command line tool to create XML files from a
database, but you can directly use ADO.

The VB code to perform the "XML from ADO" functionality is:

==============================
Dim rsXML As New ADODB.Recordset
Dim sSQL As String, sConn As String

sSQL = "SELECT customerid, companyname, contactname FROM customers"
sConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Program Files\Common
Files\System\msadc\samples\NWind.mdb"
rsXML.Open sSQL, sConn
rsXML.Save "c:\nwind.xml", adPersistXML
==============================

You should be able to easily build a Visual Basic application, or a
VBScript file starting from this code.

Hope this helps,
Alberto

   
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.