Well, just prepared a Generator which take a SQL statment as src, and generate multi-level XML document.
Please kindly give me some comments? http://www.evansho.net/SqlGenerator.zip BTW, how should I do pagination in cocoon? I mean if I have 100+ rows and want to display them page by page with 10 rows per page, is there any general practice to do that? Regards Evan --- Christian Haul <[EMAIL PROTECTED]> wrote: > On 12.May.2002 -- 10:17 AM, Evan Sho wrote: > > 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? > > Have a look at <esql:group/>. It's not automatic as > such but obtaining > a result like the above would be easy. Alas, the > query needs to be > known beforehand. > > An automatic tools would need to have more knowledge > about database > metadata and parse the query. > > HTH > > Chris. > > -- > C h r i s t i a n H a u l > [EMAIL PROTECTED] > fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 > 6856 335A 9E08 > > > --------------------------------------------------------------------- > 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: > <[EMAIL PROTECTED]> > For additional commands, e-mail: > <[EMAIL PROTECTED]> > __________________________________________________ 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
