|
Home > Archive > BizTalk Server General > March 2004 > TRANSACTION FAILURE WITH DOUBLE QUOTES
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 |
TRANSACTION FAILURE WITH DOUBLE QUOTES
|
|
| Phillip 2004-03-22, 8:37 am |
| Does anyone know why I get a particular Transmission failure when using BizTalk with AIC SQL Adaptor to write to an SQL database via a Stored Procedure? The failure only occurs when field data contains either a literal ? (quotation mark) or the " (e
ntity encoding)! This data parses correctly and is well formed XML. All other XML special characters work fine (> < ' &) except this one. In fact, a literal quotation mark (?) gets converted to " but still fails with a Transmission
error. I belive it must be something to do with the second quotation mark becoming a delimter and terminating the data string, when it should be some quoted text. Example:
<param7 name="AddressLine1" value=""My House"" />
Any help on this problem much appreciated.
Phil Wales UK.
Sent via http://www.biztalkug.com
everything about BizTalk Server
| |
| Ryan Morreau 2004-03-22, 5:36 pm |
| I think that if you escape your double-quote with 2 double quotes it should
work as espected. You are correct in saying that the second quote is
terminating the data string.
Example: <param7 name="AddressLine1" value="""My House""" />
Ryan
"Phillip" <phil.roscoe@carmarthen.wales.nhs.uk> wrote in message
news:NH3Hz3L81U@biztalkug.com...
> Does anyone know why I get a particular Transmission failure when using
BizTalk with AIC SQL Adaptor to write to an SQL database via a Stored
Procedure? The failure only occurs when field data contains either a
literal ? (quotation mark) or the " (entity encoding)! This data
parses correctly and is well formed XML. All other XML special characters
work fine (> < ' &) except this one. In fact, a literal
quotation mark (?) gets converted to " but still fails with a
Transmission error. I belive it must be something to do with the second
quotation mark becoming a delimter and terminating the data string, when
it should be some quoted text. Example:
>
> <param7 name="AddressLine1" value=""My House"" />
>
> Any help on this problem much appreciated.
>
> Phil Wales UK.
>
>
> Sent via http://www.biztalkug.com
> everything about BizTalk Server
>
| |
|
| Thanks Ryan! Appreciate your reply. I think I've proved
that failure occurs when the data (value) is passed as a
parameter in the SQL stored procedure, including the outer
quotes.
I spoke to the developer resonsible for creating the XML
data output used, and he has ammended his system to 'strip-
out' double quotes from the data. Actually, there were
only 12 records in 245,000 that contained double quotes.
Anyway, problem solved (sort of) I quess.
Thanks Phil.
>-----Original Message-----
>I think that if you escape your double-quote with 2
double quotes it should
>work as espected. You are correct in saying that the
second quote is
>terminating the data string.
>
>Example: <param7 name="AddressLine1" value="""My
House""" />
>
>Ryan
>
>"Phillip" <phil.roscoe@carmarthen.wales.nhs.uk> wrote in
message
>news:NH3Hz3L81U@biztalkug.com...
failure when using[color=darkred]
>BizTalk with AIC SQL Adaptor to write to an SQL database
via a Stored
>Procedure? The failure only occurs when field data
contains either a
>literal ? (quotation mark) or the " (entity encoding)!
This data
>parses correctly and is well formed XML. All other XML
special characters
>work fine (> < ' &) except this one. In fact, a
literal
>quotation mark (?) gets converted to " but still fails
with a
>Transmission error. I belive it must be something to do
with the second
>quotation mark becoming a delimter and terminating the
data string, when
>it should be some quoted text. Example:
>
>
>.
>
|
|
|
|
|