need help badly newbie question

  • 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.

    i tried this

    SELECT item_number, error_code, Qty FROM xml_file_item_errors FOR XML AUTO, TYPE

    and gave me this result.

    please help.

  • I can't see your required XML output. Can you edit your post to make it visible using the IFCode if you can.... You may need to replace < symbols with < code and > symbols with > code.

    ("<" - That's not easy to write :crazy: )

    Thanks



    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply