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
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
harel kaplanSubject: mysql and xml/sql
Author: harel kaplan
Date: 22 Apr 2006 04:36 PM
Originally Posted: 22 Apr 2006 04:32 PM
hi, im using your trial enterprise vergin.<br> i tried to connect my db to the xml file, by the guide<br> db-to-xml-update.wmv (sorry but i dont have the link).<br> im using mysql server.<br> i did everything like the guide, i managed to work with the<br> mysql server:<br> i reached contact with the db,<br> i dragged the specific table to the left screen, pressed "select (sql/xml)".<br> i moved to the "update" tab, dragged the specific table to the left screen, pressed "insert..." <br> i saved the result in a file named "books.rdbxml",<br> when i opened it after i saved it, it was great, exactly like i saved it.<br> until that point everything went great.<br> than i tried to use the 'XSLT:mapper', when i tried to open the file "books.rdbxml"(in the right place -set target document),<br> it oppened the file but not as expected, the file was almost empty, it lost all its nodes,elements...<br> it changed the file i saved, it ruined it.<br> i tried it several times and i ended up with the same result.<br> <br> sorry for my bad english, hope u could halp.


Imagepro.JPG

Postnext
Ivan PedruzziSubject: mysql and xml/sql
Author: Ivan Pedruzzi
Date: 22 Apr 2006 04:56 PM

Did you try to run the select statement from DB to XML?

Does the table "books" contain records?

when using db:///books.rdbxml in mapper Stylus Studio is running the SELECT statement under the cover.

hope this helps
Ivan Pedruzzi
Stylus Studio Team

Posttop
harel kaplanSubject: thanks u, the problem was the empty table
Author: harel kaplan
Date: 22 Apr 2006 05:37 PM

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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!  
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.