Re: sql adapter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Isn't that a little overkill? I would rather make sure the node is not
generated with a carriage return in it.

"Francisco A. Gonzalez" <fgonzalez@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:eVJiSs9PHHA.4156@xxxxxxxxxxxxxxxxxxxxxxx
You can erase the carriege return using a Map.

Francisco A. Gonzalez
fgonzalez@xxxxxxxxxxxxxxxxxxxxxxxx


"Jocelyn" <Jocelyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7DC25EAF-7F34-4D84-AD6D-5D449281205F@xxxxxxxxxxxxxxxx
I've developed a orchestration which includes a step to insert a new row
into
a sql server database table using data from an incoming xml file.

The query that I have relates to empty elements in the incoming xml file.
If the opening and closing tags are on the same line e.g.<name></name>,
then
nothing is inserted into the corresponding database column as expected.

However, if the opening and closing tags are on separate lines e.g.
<name>
</name>

then the line feed carriage return characters are written to the
database.




.

Relevant Pages

  • Re: sql adapter
    ... you have a carriage return in the field. ... The query that I have relates to empty elements in the incoming xml file. ... nothing is inserted into the corresponding database column as expected. ...
    (microsoft.public.biztalk.general)
  • Re: sql adapter
    ... generated with a carriage return in it. ... a sql server database table using data from an incoming xml file. ... The query that I have relates to empty elements in the incoming xml ... nothing is inserted into the corresponding database column as expected. ...
    (microsoft.public.biztalk.general)
  • Re: sql adapter
    ... Francisco A. Gonzalez ... a sql server database table using data from an incoming xml file. ... The query that I have relates to empty elements in the incoming xml file. ... nothing is inserted into the corresponding database column as expected. ...
    (microsoft.public.biztalk.general)
  • Re: Formatting an inserted database field
    ... stop inserting unnecessary and unwanted Carriage Returns. ... DATABASE fields at some point which does cause an unhelpful extra ... When viewing the document without Show/Hide formatting selected (and ...
    (microsoft.public.word.mailmerge.fields)
  • RE: non relational database
    ... I commend you for letting the person who designed the database live - very ... In terms of splitting the strings, if each bit of data is delimited ... by a carriage return, you could write a VBA function that reads ... special character you may not be able to use it. ...
    (microsoft.public.access.modulesdaovba)