RE: [xml-dev] Default Entity when compose xml file

["Michael Rys" <mrys@microsoft.com>]

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@yahoo.com.cn]
> Sent: Thursday, October 27, 2005 1:22 AM
> To: xml-dev@lists.xml.org
> Subject: [xml-dev] 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 &lt;, &gt;,&amp; 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>