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


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: [xml-dev] XML into SQL and out again

[ Lists Home | Date Index | Thread Index ]

Neile, Jonathan, maybe you'd be interested in having a look at the data
binding portion of the o:XML Database Extensions:


an equivalent to Jonathans example, giving the same result XML, is
attached below:

On Fri, 28 Mar 2003, Jonathan Robie wrote:

> select
>      xmlelement ( name "employee",
>          xmlattributes (e.EmpId as "id"),
>          xmlelement ( name "names",
>              xmlelement ( name "first", e.FirstName),
>              xmlelement ( name "last", e.LastName)
>          )
>      )
> from  Employees   e

o:XML version ->>

<db:execute sql="select * from Employees">
  <employee id="[EmpId]">

as you can see it separates the SQL from the XML, and the embedded result
template lets you decide exactly what the XML will look like.

however, the more powerful part of o:XML db is in passing parameters and
doing nested queries.

the ObjectBox, including db extensions, is free for most use and will be
completely open sourced with the next version (due out soon).

best regards,


Martin Klang
http://www.o-xml.org - the object-oriented XML programming language


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

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