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