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


Help: OASIS Mailing Lists Help | MarkMail Help



   Embedding SQL statements in XML

[ Lists Home | Date Index | Thread Index ]
  • From: Michel Rodriguez <mrodrigu@ieee.org>
  • To: xml-dev@lists.xml.org
  • Date: Tue, 14 Nov 2000 14:06:47 -0500 (EST)


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 variously
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 like 

<p> text <sql_value db="db1" query="select price from book where
isbn=123456"> more text</p>

for single values and like

<tr><sql_row db="db2" query="select title, price from book where

for rows

Would anyone know of anything in this area?

Thank you

Michel Rodriguez
Perl & XML


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

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