[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Embedding SQL statements in XML
Hi, 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 Would anyone know of anything in this area? Thank you Michel Rodriguez Perl & XML
|
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
|