soumyadeeplodh Posted July 15, 2015 Share Posted July 15, 2015 I have one database(MySQL) where data type of one column is XML. Like the table name is 'class_5_student' and two columns is there- > std_roll_num [iNT]> std_dtl for example std_roll_numstd_dtl1<std_1><name>Tom</name><age>10</age><roll>1</roll></std_1>2<std_2><name>Sam</name><age>11</age><roll>2</roll></std_2>3<std_3><name>Lisa</name><age>10</age><roll>3</roll></std_3>I know how to connect XML datasource and fetch data from XML file. Is it possible to get data from above table and generate report like -NameRollAgeTom110Sam211Lisa310Every time I connect this DB, I always get XML column as string.Please help. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now