Need help with script to get resource data from database

[thelonejedi]

So far I have this but when trying to covert this to XML it doesn't separate enough data info into groups.

SELECT resource_id, resource_name, resource_class, regexpsubstr(attributes, '[[:alpha:]]+', 1, lines.column_value) attribute_name, regexp_substr(attributes, '\d+', 1, lines.column_value) attribute_value FROM resource_types, TABLE (CAST (MULTISET (SELECT LEVEL FROM dual CONNECT BY regexp_substr(attributes, '[^:]+', 1, LEVEL) IS NOT NULL) AS sys.odciNumberList)) lines WHERE depleted_timestamp >= (SELECT last_save_time FROM clock);

Can anyone help please

[thelonejedi]

Is there noone that can help with this ??

[Shozzo]

I don't what database this is pulling from, but from SQL Server you would add FOR XML AUTO; to the end of the query for it to return as XML.
If this is MySQL or Oracle you'd have to google how to get the results to return as XML. 

[KevinsCaw]

skaskanew.rugratiavitae.ruslame-rp.ruagrorubo.ruflamandrose.rufantastikmir.rupavel3333.ruvladgate.ruvr-point.ruhomeimprovementstore.rucraftingmaterials.rumodernlighting.ru

[KevinsCaw]

skaskanew.ru source gratiavitae.ru read more slame-rp.ru details agrorubo.ru more info on this page flamandrose learn more fantastikmir the article pavel3333 pavel3333 vladgate visit the site vr-point.ru click here to learn more homeimprovementstore visit the site for details craftingmaterials.ru that modernlighting learn more digitalartprints.ru here beautyandwellness.ru details

[KevinsCaw]

skaskanew.ru this website gratiavitae learn more about this slame-rp.ru source agrorubo.ru go to flamandrose link fantastikmir click here to learn more pavel3333 the article vladgate.ru more info on this page vr-point site homeimprovementstore.ru source craftingmaterials.ru more info on this page modernlighting.ru link digitalartprints.ru the article beautyandwellness the article