xml-dev - Re: Embedding SQL statements in XML

["Thomas B. Passin" <tpassin@home.com>]

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.

Cheers,

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
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
> isbn=123456"></tr>
>
> for rows
>