| Pierre CHALAMET 2005-05-31, 7:47 am |
| Hi,
I'm having troubles with the SQL Adapter. It seems that using the dollar
sign in the first position of a data leads to serious problems.
Here is the XML that is sent to an SQL send port (the target table has a
facilityId (varchar) column and an amount (float) column.
<OutstandingsRequest xmlns="http://outstandings.sgcibml">
<sync><after>
<temp_Outstanding facilityId="$J5EZEFN" amount="1407670.00" />
</after></sync>
</OutstandingsRequest>
What cause a failure to insert into the database is because of the attribute
facilityId="$J5EZEFN".
I already asked this question on the sqlserver.sqlxml newsgroup and it seems
that facilityId is automatically mapped to a currency datatype.
How could I prevent this kind of mapping ? I actually need to insert the
dollar ($) and I do not want to use a stored procedure + altering the data
just to make this work.
Thanks,
- Pierre
|