OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: Embedding SQL statements in XML

[ Lists Home | Date Index | Thread Index ]
  • From: "Thomas B. Passin" <tpassin@home.com>
  • To: Michel Rodriguez <mrodrigu@ieee.org>, xml-dev@lists.xml.org
  • Date: Tue, 14 Nov 2000 22:21:01 -0500

It's not xml, but Cold Fusion does a lot of what you are
talking about.  You could always write Cold Fusion templates
to output xml.


Tom Passin

Michel Rodriguez asked -

> I was wondering whether some work, maybe standardization
work, has been
> done on embedding data from a relational database into an
XML document.
> The document is processed to generate the complete XML
document, but the
> non-processed version is the one that is edited and
managed in the system.
> I have found no trace of public work on that topic,
although I know of a
> couple of old SGML implementations.
> I realize that various type of results can be required,
from a single
> value to a complete table, through one or more rows or
columns (columns
> being even trickier than rows). Plus the queries can be
> parametrized and connection to the DB is always a problem.
But I am
> surprized not to find _anything_ on the subject.
> I am looking at something like standard fragments looking
> <p> text <sql_value db="db1" query="select price from book
> isbn=123456"> more text</p>
> for single values and like
> <tr><sql_row db="db2" query="select title, price from book
> isbn=123456"></tr>
> for rows


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS