• Post Reply Bookmark Topic Watch Topic
  • New Topic

Hi generating XML response from a database using Group_Concat  RSS feed

 
Dushyant Chhetri
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Hi Guys,



I need to generate the above code from a table in DB.
The problem is I am able to generat ea structure as


However I am unable to generate the cascading child structure where there are more than one nodes.

Please suggest me a way out
is it possible to draw such a response for a webservice using Group_concat???

my code was something like

 
Ivan Krizsan
Ranch Hand
Posts: 2198
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi!
Please see: http://www.coderanch.com/t/472136/Web-Services/java/Retrieving-xm-from-mySQL-sending
Your problems is another very good reason not to use the tactic in which you mix XML generation and SQL queries.
Best wishes!
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!