|
Home > Archive > BizTalk Server General > April 2006 > How to avoid 'ns0' in XML result using SQL adatpter
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 |
How to avoid 'ns0' in XML result using SQL adatpter
|
|
| killbill 2006-03-14, 5:52 pm |
| Hi All,
I am using SQL adapter to fetch data from database. It returns data in
XML and add 'ns0' with all tags, like; <ns0:FirstName>. How i can
avoide 'ns0' ???
Any suggestion ?
| |
| Anirudha Vengurlekar 2006-03-14, 5:52 pm |
| When you generate schema form wizard:
- Attribute FormDefault is always set to Unqualified
- Element FormDefault is always set to Qualified
As a result you element are fully qualified. (i.e. with namespace prefix)
If you change the Element FormDefault to Unqualified, then probably you
will not have namespace prefix.
Hope this will help you.
Thanks,
Ani
"killbill" wrote:
> Hi All,
>
> I am using SQL adapter to fetch data from database. It returns data in
> XML and add 'ns0' with all tags, like; <ns0:FirstName>. How i can
> avoide 'ns0' ???
>
> Any suggestion ?
>
>
| |
| Anirudha Vengurlekar 2006-03-14, 5:52 pm |
| When you generate schema form wizard:
- Attribute FormDefault is always set to Unqualified
- Element FormDefault is always set to Qualified
As a result you element are fully qualified. (i.e. with namespace prefix)
If you change the Element FormDefault to Unqualified, then probably you
will not have namespace prefix.
Hope this will help you.
Thanks,
Ani
"killbill" wrote:
> Hi All,
>
> I am using SQL adapter to fetch data from database. It returns data in
> XML and add 'ns0' with all tags, like; <ns0:FirstName>. How i can
> avoide 'ns0' ???
>
> Any suggestion ?
>
>
| |
| Will F 2006-04-27, 7:26 am |
| In your destination schema, remove the value from the "Target Namespace"
property. When you build the solution, you will see a warning to the effect
that the schema has a Null target namespace, but I have not found it to
create any errors.
"killbill" wrote:
> Hi All,
>
> I am using SQL adapter to fetch data from database. It returns data in
> XML and add 'ns0' with all tags, like; <ns0:FirstName>. How i can
> avoide 'ns0' ???
>
> Any suggestion ?
>
>
|
|
|
|
|