Since these are all converted to Oracle datatype Number then 2.5 is the same as 2.50 and is not being truncated. Oracle will not store more data then it needs and even though it is a price 2.5 is still 2.50 and is also 2.5000000000
In CFQUERYPARAM the type only does validation so if you are doing a cf_sql_float but the database datatype is still NUMBER then it will treat it as a true integer. Depending on what database you are using use FLOAT or just stick with NUMBER and then do DollarFormat on all display code (which is how we handle money here as a standard). And please for the sake of all of those that have to work on your code after you do not put "$2.50" into a varchar field... yeah we have seen that done too :-) J.J. Merrick daniel kessler wrote: >>This is standard practice - try entering it as a CF_SQL_FLOAT or >>something.....or alter the datatypes length and precision. > > > Float didn't work. 2.50 became 2.5. Interestingly though in all cases 2.51 > stays fine so it seems that the lenght is fine and it's the precision that > needs changing. I suppose that I can do that in sql. That's the next thing > to look up. > > thanks Neil. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213104 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
