[
Lists Home |
Date Index |
Thread Index
]
hi Michael,
I agree this is one solution. Perhaps I can not use
this methods if I want to get database independent
capability. Is there any uniform methods in database
which like SQL standard to do this? Since each
database vender has it's own methods and support
different language in the database.
Thansk and Regards,
Long
--- Michael Rys <mrys@microsoft.com> wrote:
> 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 <, >,& 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>
>
>
>
-----------------------------------------------------------------
> 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>
>
>
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
|
