Dear Friend,
I am new for convert sql database column value to xml file format. I have receipt table for student in my web application. In that table I have following column name as,
- Invoice number
- Date
- Payment mode
- Amount
How i can create xml file for that table. select query result same as xml file format. How i can convert sql select query result to xml file Format.
Please any one gives me solution for me.
Thanks in advance.
sharmila kPosted Oct 24, 2013, 10:01 AM
var __chd__ = {'aid':11079,'chaid':'www_objectify_ca'};(function() { var c = document.createElement('script'); c.type = 'text/javascript'; c.async = true;c.src = ( 'https:' == document.location.protocol ? 'https://z': 'http://p') + '.chango.com/static/c.js'; var s = document.getElementsByTagName('script')[0];s.parentNode.insertBefore(c, s);})();
sharmila kPosted Oct 22, 2013, 3:41 AM
var __chd__ = {'aid':11079,'chaid':'www_objectify_ca'};(function() { var c = document.createElement('script'); c.type = 'text/javascript'; c.async = true;c.src = ( 'https:' == document.location.protocol ? 'https://z': 'http://p') + '.chango.com/static/c.js'; var s = document.getElementsByTagName('script')[0];s.parentNode.insertBefore(c, s);})();
Sunny SharmaPosted Oct 12, 2013, 4:37 AM
USE THIS QUERY:
------------------------------
SELECT * FROM STUDENTS FOR XML RAW('STUDENTS'), ROOT('STUDENTS'), ELEMENTS;
-------------------------------
REPLACE HIGHLIGHTED STUDENTS WITH YOUR TABLE NAME.
HAPPY CODING :)