[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Embedding SQL statements in XML
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 >
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|