[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Default Entity when compose xml file
What database system are you using? Most relational database systems provide some form of rel->XML mapping functionality that will take care of the entitization. See the XML Publishing functions in Oracle or DB2 or the "FOR XML" clause in SQL Server... In SQL Server 2005 for example, the following query would give you the required transformation (with taking care of entitization of <,> etc): SELECT "User name" as "name", description FROM table FOR XML PATH('person'), ROOT('Data') Best regards Michael > -----Original Message----- > From: jj long [mailto:longjingjun@y...] > Sent: Thursday, October 27, 2005 1:22 AM > To: xml-dev@l... > Subject: Default Entity when compose xml file > > hi experts, > > I want to retrieve data from database and compose all > of the data in to a xml file. For example: > Data: > User name description > ------------------------------------- > Philips This is a funny guy > adam Administrator > > XML: > <Data> > <person> > <name>Philips</name> > <description>This is a funny guy</description> > </person> > <person> > <name>adam</name> > <description>Administrator</description> > </person> > </Data> > > My problem is: > Sometims, there are <,>,& or other character in the > data and these character can not directly used in xml > file. > > What is your suggestion from your expierence? > > One solution I am thinking about is: > Replace <,>,& and other characters that can not used > directly in xml data with <, >,& and etc in > the data before I compose the xml file. > > An other problem is risen here. Are these entities > been defined as default entity in the parser (Xerces)? > I.e.: can I do not define these entities in the xml > file? > > Thanks, > > Long > > > > __________________________________ > Yahoo! FareChase: Search multiple travel sites in one click. > http://farechase.yahoo.com > > ----------------------------------------------------------------- > The xml-dev list is sponsored by XML.org <http://www.xml.org>, an > initiative of OASIS <http://www.oasis-open.org> > > The list archives are at http://lists.xml.org/archives/xml-dev/ > > To subscribe or unsubscribe from this list use the subscription > manager: <http://www.oasis-open.org/mlmanage/index.php>
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|