>>If you do a simple query and cfdump the result, do you get a period or comma?
Yes I do.
But I finaly found the problem.
The query is produced by a UNION, and in one of the sub SELECTs, the column was set to '0' instead of 0. This tiggered a converstion to text for the same column in the next SELECT, probably in the ODBC driver, and this conversion implied the use of a comma instead of a dot. For some unknown reason, it follows the rule for French because the version of Windows is French, but bypasses the settings in Windows.
Kind of weird indeed, you're right, it should cause an error.
Databases frequently do implicit conversion on string values. So I would not expect an error unless the string could not be converted to the numeric data type its being merged with. That is how it works in sql server. For example, this automatically converts the string '0' to numeric (or whatever data type is used)
SELECT '0' AS Test
SELECT cast(10.50 as numeric(10,2))
Message was edited by: -==cfSearching==-