need help badly newbie question

[tengtium]

can somebody help me. i have this simple record.

error_reference _uid item_number error_code
1234567 13579 odd
1234567 2468 even
and i want to create this xml.

<Errors error_reference _uid="1234567">
<Error item_number="13 579" error_code="odd " />
<Error item_number="24 68" error_code="eve n" />
</Errors>

i tried this

SELECT item_number, error_code, Qty FROM xml_file_item_e rrors FOR XML AUTO, TYPE

<xml_file_item_ errors error_reference _uid="1234567" item_number="13 579" error_code="odd " />
<xml_file_item_ errors error_reference _uid="1234567" item_number="24 680" error_code="eve n" />

and gave me this result.


please help.

[jkmyoung]

How do you want to fix this? Through a pass through script, using a simple search replace?

Through specifically specifying your xml format when using your query?

[tengtium]

yes through a query.. given the set of record. i wanted to create an xml using the said format. can you help