Cart
[Home] [By Thread] [By Date] [Recent Entries]
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
|
