Hi there, We have just upgraded to CFMX 6.1 and we are having an issue with either CFMX, or the JDBC drivers reading from our SQL 7 database.
The problem centers around any float field in the DB, (e.g. 1.0). I can look it up the value of this field in SQL query analyser and get '1.0'. However, if I read that value into a variable, or even just use a cfdump from a query the value I get is not '1.0', but instead '1' - i.e. the value is truncated before the decimal point. This only happens if the number is x.0 - reading in 0.75 from the DB results in 0.75, as you might expect. Does any one know whats is going on here? Is it a problem with the driver SETTINGS, that it doesn't pad decimals with nothing after the decimal point? Is it a SQL server problem? Cheers for any help - I am tearing my hair out :) Ciaran ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
