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

http://www.o-xml.org/objectbox/db.html

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]"> 
    <names> 
      <first> [FirstName]</first>
      <last> [LastName]</last>
    </names> 
  </employee> 
</db:execute> 

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,

/m

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


-----------------------------------------------------------------
The xml-dev list is sponsored by XML.org <http://www.xml.org> , an
initiative of OASIS <http://www.oasis-open.org> 

The list archives are at http://lists.xml.org/archives/xml-dev/

To subscribe or unsubscribe from this list use the subscription
manager: <http://lists.xml.org/ob/adm.pl>