[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Embedding SQL statements in XML
Besides the reference to the excellent overview page at http://www.rpbourret.com that was already mentioned, I would like to point you to the template mechanisms that many database vendors provide (some tool-vendors already pointed to theirs). Examples are the SQLX templates in Oracle 8i (that you already found), DADs in IBM DB2 and last but certainly not least the query templates of SQLServer 2000 (that I find to be the best of the bunch but then I am biased :-)). There is currently no standardization of the mechanism for various reasons. The SQL community is now starting to investigate XML related issues to standardize. I do not think that it is the W3C's role to issue recommendation on relational database specific technology, but then again, I may be wrong on this.... Best regards Michael -- Program Manager, SQL Server XML Technologies mrys@m..., rys@a... We store the Web and more... > -----Original Message----- > From: Michel Rodriguez [mailto:mrodrigu@i...] > Sent: Tuesday, November 14, 2000 11:07 AM > To: xml-dev@l... > Subject: 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
|