- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
Total Likes