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.

Reply via email to