on 08-02-2012 1:12 PM
Hi All,
First of all I would like to thank all the members of this forum for their tremendous support provided so far. I am facing with one issue and need some help from you all. Here is my requirement
1) I am invoking an SQL procedure from MII which is written on SQL Server
2) This procedures returns one value (Out Parameter) which is in xml format
3) When I catch the value in MII I can see that all '>' chars are replaced with '>' in MII
4) I think MII returns the data in an xml format. So one xml data inside another one makes issue
Can anyone tell me how can I resolve this issue. I would like to assing the xml value which is returned by the procedure to another xml variable in MII.
I am using MII 12.1.9 version
Any help on this is very much appreciated
Thanks
Shaji
I would almost question why you are returning xml from the stored proc. Might be easier to return just the single value as is or in a table if the need for multi values might arrise. That way Mii returns the value(s) right away in the Mii xml format.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try using the xmldecode function in the link editor.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
6 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.