Hi all, 

I have a trouble with a special field's value. My require is that I must ret
urn 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

[ Post a follow-up to this message ]

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
>

[ Post a follow-up to this message ]

This is a way IE displaies XMLs.
You can right click on the IE view and select "View Source" to see all the s
paces.

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!TK2M
SFTNGP08.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 mess
age are best directed to the newsgroup/thread from which they originated.

[ Post a follow-up to this message ]