XML Help.. adding a root to the root?

  • oogibah

    Say Hey Kid

    Points: 679

    I have a XML output that gets output into a file for BizTalk to send to another company, and I'm trying to format the Root clause the way they want but its a bit bizzare and I'm having trouble

    This is how they want it formatted:

    <GIAS xmlns="GIAS_PolicyEquipment_New">
    <ROOT xmlns="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <Certdata>

    ...

    ...

    </GIAS>

    if I try to use WITH XMLNAMESPACE it just put its after the <ROOT xmlns:xsi="HTTP://...>

    like this

    <GIAS xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:GIAS="xmlns=GIAS_PolicyEquipment_New">
    <Certdata>

    I've tried to specify the root but unfortunately I'm pretty bad with HTML, this is simply a select statement not an insert was wondering if I could get some assistance here.

     

    Thanks!

  • Site Owners

    SSC Guru

    Points: 80380

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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