Can you reply with the line of code throwing that error and perhaps a few relevant lines above it?
On Tue, Apr 17, 2012 at 1:45 PM, <> wrote: > > Hi, > I have CF9 installed on W7 using an Access database. > In a table I have a currency value of -488.7 > The windows is French, but I have set the delimiter for both the decimal > values AND currency values to dot instead of comma. > Though I get this error in CF: > The value -488,7 cannot be converted to a number. > CF is receiving the value with a comma instead of a dot. > - If I browse the table under Access, the value is correctly displayed > with a dot. > - If I modify the column type to teTEXT instead of real or currency, the > value is converted to text with a dot, and there is no error in CF. > Obviously a conversion from dot to comma is made in some other layer, but > where? > I've checked in the ODBC connection and found nothing. > > Any idea? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350768 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
