cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Evan Sho <in...@evansho.net>
Subject Generate multi-level XML document using standard SQL select statement
Date Sun, 12 May 2002 17:17:52 GMT
Just tried MS SQL server 2000. I can type in browser:
http://localhost/mydb?sql=select * from dept, emp
where dept.deptno=emp.dept.no for xml auto&root=List

then, I will get XML:
<List>
  <dept id='10' name='Sales'>
    <emp id='10' name='King' salary='5000'/>
    <emp id='20' name='John' salary='200'/>
  </dept>
  <dept id='20' name='Account'>
    <emp id='30' name='Peter' salary='2000'/>
  </dept>
  ...
</List>

The nesting of joined result is automatic, and I found
that it is very useful. so is there any similar tool
that can be used to get similar result?

Thanks
Evan



__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message