cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Evan Sho <>
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 for xml auto&root=List

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

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?


Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience

Please check that your question has not already been answered in the
FAQ before posting. <>

To unsubscribe, e-mail: <>
For additional commands, e-mail: <>

View raw message