Avatar

Level 3

Hello Jasmin,

I'm getting my xml as:

<Email>
    <EmailId>
        <mailId type="nvarchar">,abcd@xyz.com</mailId>
    </EmailId>
    <EmailId>
        <mailId type="nvarchar">,efgh@pqr.com</mailId>
    </EmailId>
    <EmailId>
        <mailId type="nvarchar">,lmop@abc.com</mailId>
    </EmailId>
</Email>

Finally I want: "abcd@xyz.com ,efgh@pqr.com ,lmop@abc.com"

I'm using Serialize to convert xml to string.

/process_data/@EmailIds = serialize(/process_data/EmailIdsFromDB, true())

It is giving only the first node's value and rest of the xml will be there in the string.  The whole string after serialize will be:

,abcd@xyz.com</mailId>
    </EmailId>
    <EmailId>
        <mailId type="nvarchar">,efgh@pqr.com</mailId>
    </EmailId>
    <EmailId>
        <mailId type="nvarchar">,lmop@abc.com</mailId>
    </EmailId>
</Email>

How can i get only the email ids one after the other so that i can use that string on my Email control's 'TO' box.

Thanks

Deepak