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

[ Post a follow-up to this message ]