How to avoid 'ns0' in XML result using SQL adatpter
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server General > How to avoid 'ns0' in XML result using SQL adatpter




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    How to avoid 'ns0' in XML result using SQL adatpter  
killbill


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
03-14-06 10: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 ?






[ Post a follow-up to this message ]



    RE: How to avoid 'ns0' in XML result using SQL adatpter  
Anirudha Vengurlekar


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
03-14-06 10: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 ?
>
>





[ Post a follow-up to this message ]



    RE: How to avoid 'ns0' in XML result using SQL adatpter  
Anirudha Vengurlekar


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
03-14-06 10: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 ?
>
>





[ Post a follow-up to this message ]



    RE: How to avoid 'ns0' in XML result using SQL adatpter  
Will F


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
04-27-06 12:26 PM

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 ?
>
>





[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 03:48 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register