[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: XML into SQL and out again

• To: Jonathan Robie <jonathan.robie@d...>
• Subject: Re: XML into SQL and out again
• From: <martin@h...>
• Date: Fri, 28 Mar 2003 16:08:42 +0000 (GMT)
• Cc: Neile Bermudes <Neile.Bermudes@e...>, <xml-dev@l...>
• In-reply-to: <5.2.0.9.0.20030328085754.0702d9b8@n...>

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

• References:
  • Re: XML into SQL and out again
    • From: Jonathan Robie <jonathan.robie@d...>

• Prev by Date: Re: If XML is too hard for a programmer, perhaps he'd be better off as a crossing guard
• Next by Date: RE: If XML is too hard for a programmer, perhaps he'd be better off as a crossing guard
• Previous by thread: Re: XML into SQL and out again
• Next by thread: Re: XML into SQL and out again
• Index(es):
  • Date
  • Thread