|
Home > Archive > BizTalk Server General > September 2004 > "space" in .xml
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]
|
|
|
| Hi all,
I have a trouble with a special field's value. My require is that I must return a 'space' value for a field if it not present in input file. However, I receive a field like this (open with IE):
<TORI_CD/>
(if I open it in text format, it probadly show :
<TORI_CD> </TORI_CD> )
but I want it to display (in IE):
<TORI_CD> </TORI_CD>
Actually, I am using an database adapter and I want to see my SQL command :
"Insert into TORI(TORI_CD(char 6),TORI_MEI) values(' ','Hallo')"
istead of :
"Insert into TORI(TORI_CD(char 6),TORI_MEI) values('','Hallo')"
The reason is that TORI_CD is one of primary keys and I want to put a 'space' value for it if input value is null
Thanks in advance
pcl | |
| Devdutt Patnaik 2004-09-23, 5:51 pm |
| Try this...use that field as an Attribute.
<TORI_CD Value=" "/>
"pcl" <pcl.1cztw0@mail.webservertalk.com> wrote in message
news:pcl.1cztw0@mail.webservertalk.com...
>
> Hi all,
>
> I have a trouble with a special field's value. My require is that I
> must return a 'space' value for a field if it not present in input
> file. However, I receive a field like this (open with IE):
>
> <TORI_CD/>
> (if I open it in text format, it probadly show :
> <TORI_CD> </TORI_CD> )
>
> but I want it to display (in IE):
>
> <TORI_CD> </TORI_CD>
>
> Actually, I am using an database adapter and I want to see my SQL
> command :
>
> "Insert into TORI(TORI_CD(char 6),TORI_MEI) values(' ','Hallo')"
>
> istead of :
>
> "Insert into TORI(TORI_CD(char 6),TORI_MEI) values('','Hallo')"
>
> The reason is that TORI_CD is one of primary keys and I want to put a
> 'space' value for it if input value is null
>
> Thanks in advance
> pcl
>
>
>
> --
> pcl
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message395752.html
>
| |
| Tatyana Yakushev [MSFT] 2004-09-24, 5:49 pm |
| This is a way IE displaies XMLs.
You can right click on the IE view and select "View Source" to see all the spaces.
Thanks,
Tatyana
--------------------
>From: pcl <pcl.1cztw0@mail.webservertalk.com>
>Subject: "space" in .xml
>Date: Thu, 16 Sep 2004 02:04:38 -0500
>Message-ID: <pcl.1cztw0@mail.webservertalk.com>
>Organization: Web Servers forum
>User-Agent: www.webservertalk.com news gateway
>X-Newsreader: www.webservertalk.com news gateway
>X-Originating-IP: 203.113.150.149
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: ev1s-207-44-136-62.ev1servers.net 207.44.136.62
>Lines: 1
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:19783
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>
Hi all,
>
>I have a trouble with a special field's value. My require is that I
must return a 'space' value for a field if it not present in input
file. However, I receive a field like this (open with IE):
>
><TORI_CD/>
>(if I open it in text format, it probadly show :
><TORI_CD> </TORI_CD> )
>
>but I want it to display (in IE):
>
><TORI_CD> </TORI_CD>
>
>Actually, I am using an database adapter and I want to see my SQL
command :
>
>"Insert into TORI(TORI_CD(char 6),TORI_MEI) values(' ','Hallo')"
>
>istead of :
>
>"Insert into TORI(TORI_CD(char 6),TORI_MEI) values('','Hallo')"
>
>The reason is that TORI_CD is one of primary keys and I want to put a
'space' value for it if input value is null
>
>Thanks in advance
>pcl
--
pcl
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message395752.html
>
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
|
|
|
|
|