<body bgcolor="#FFFFFF" background="https://img.web.de/v/p.gif" class="bgRepeatYes" style="; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); font-family: verdana, geneva; font-size: 9pt; padding-left: 0px; background-repeat: repeat repeat;"><div style="min-height: 200px; background-image: url(https://img.web.de/v/p.gif); background-repeat: repeat; background-color: #ffffff; font-family: verdana, geneva; font-size: 9pt; padding-left: 0px;">hi there!<br /><br />i wanted to ask how to get an xml output from a table like this:<br /><br /><words><br /><first_name>joe</first_name><br /><first_name>ian</first_name><br /><first_name>carl</first_name><br /><first_name>ben</first_name><br /></words><br /><br />what i have is the following:<br /><br />
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">SELECT xmlelement(name words,</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;"></div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;"></div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">xmlforest(nachname))</div>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;">FROM person</div>
SELECT <br />xmlelement(name words,<br />xmlforest(nachname))<br />FROM person<br /><br />but that gives me this:<br /><br /><words><first_name>joe</first_name></words><br /><words><first_name>ian</first_name></words><br /><words><first_name>carl</first_name></words><br /><words><first_name>ben</first_name></words><br /><br /><br />thanks in advance!<br /><br />bye, flo<br /><br /><br /> </div> <br><br><table cellpadding="0" cellspacing="0" border="0"><tr><td bgcolor="#000000"><img src="https://img.web.de/p.gif" width="1" height="1" border="0" alt="" /></td></tr><tr><td style="font-family:verdana; font-size:12px; line-height:17px;">Neu: WEB.DE De-Mail - Einfach wie E-Mail, sicher wie ein Brief! <br>Jetzt De-Mail-Adresse reservieren: https://produkte.web.de/go/demail02</td></tr></table>
</body>