|
Home > Archive > BizTalk Server General > February 2005 > SQL adapter output
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL adapter output
|
|
| ramani viswanathan 2005-02-11, 5:55 pm |
| Hi
I configured SQL adapter receive and tested. It generated the xml instance
based correctly, except it added one attribute xmlns under root node of the
instance with value = my schema name space. Is there a way that I can remove
this attribute?
The reason is that when I tried to query this instance through xmldocument ,
it always returns 0 nodes, though the instance was loaded through loadxml
method successfully. Once I removed this attribute, the query works fine.
Thanks
Ramani
| |
| Mike Watson 2005-02-12, 5:48 pm |
| hi ramani,
you can remove it from the xml instance via a biztalk map etc.. however, if
you want to query an xmldocument that has a namespace(s) then you need to
assign a namespace manager to the xmldocument. then you can run queries
(xpath etc..), no problem..
have a look @ this link.. it shows you how to do it..
http://samples.gotdotnet.com/quicks...umentXPath.aspx
you can do this directly in orchestration using the xpath function to
extract information out of an biztalk xml message. have a look @ this link:
http://geekswithblogs.net/sthomas/a...0/25/13269.aspx
- mike
"ramani viswanathan" wrote:
> Hi
>
> I configured SQL adapter receive and tested. It generated the xml instance
> based correctly, except it added one attribute xmlns under root node of the
> instance with value = my schema name space. Is there a way that I can remove
> this attribute?
>
> The reason is that when I tried to query this instance through xmldocument ,
> it always returns 0 nodes, though the instance was loaded through loadxml
> method successfully. Once I removed this attribute, the query works fine.
>
> Thanks
> Ramani
|
|
|
|
|