Re: Generate multi-level XML document using standard SQL select statement

2002-05-13 Thread Christian Haul
On 13.May.2002 -- 01:44 AM, Evan Sho wrote: > 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 Looks nice. Evan, do you like to donate that code (and so

Re: Generate multi-level XML document using standard SQL select statement

2002-05-13 Thread Evan Sho
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

Re: Generate multi-level XML document using standard SQL select statement

2002-05-13 Thread Christian Haul
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: > > > > > > > > > ... > > > The

Generate multi-level XML document using standard SQL select statement

2002-05-12 Thread Evan Sho
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: ... The nesting of joined result is automatic, and I found that it is very useful. so