I think, one fast way is: creating xml directly in mysql.
For example:
I have a table name: product(prodID, prodName)
Using MySQL query below:
-------------------------------------------------------
select CONCAT('\n<ProductList>\n',
GROUP_CONCAT('<product>\n', CONCAT('<prodID>', prodID, '</
prodID>\n') ,
CONCAT('<prodName>', prodName, '</
prodName>\n') ,
'</product>\n' order by prodID asc SEPARATOR ''),
'</ProductList>') AS xmldoc
from product;
-------------------------------------------------------
I hope it usefull.
Best regards!
--
Tao Quang Hung
Student of Information Systems Faculty
University of Information Technology, Vietnam National University - Ho
Chi Minh City.
Email: [email protected]
Mobile: 0122 949 1021
--
You received this message because you are subscribed to the Google Groups "Flex
India Community" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/flex_india?hl=en.