1) use numberFormat(n, '9.99') or decimalFormat(n) to display the value with 2 decimal places on the web page. whether it's stored as 4.1 or 4.10 in the database shouldn't be an issue. it's the same value. displaying it in a specific format should be a function of the presentation layer.
2) again, numberFormat() will put the commas in on the presentation. decimalFormat() might...not sure...need to check the docs. On 2/14/06, Roberto Perez <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm using CFMX and Access 2K (I know, I know). I was collecting some > numeric data as "text" just because I was not doing any processing of > it (getting averages, etc.), and I wanted to allow for extra > characters (e.g., dashes, commas, etc.). > > Now that I need to do some math operations on the data, I'm treating > the fields as "numeric" both by changing the field type on Access, > and by not including the single quotes in the CF queries. > > My problems: > 1 - Now each time a decimal point is followed by zeroes (e.g., > "4.00"), my zeroes dissapear from the Access field/table (the number > changes to "4"). The last zero dissapears from a number like "4.10" > (it changes to "4.1"), but the zero is kept in mid position (e.g., > "4.01 stays the same). I tried setting the Access field to "large > integer", "two decimal spaces", etc., to no avail. Is there a way to > format the CFMX query so that it somehow forces the zeroes into the > Access field? > > > 2 - Each time one of the new numeric fields contains a comma and the > field gets sent to the database, the system returns a generic error. > Again, is there a specific way of formatting that field in the query > so that commas are accepted (since they are normal components of a > number?). The decimal point does not throw an error, so I would > expect the comma to behave in a similar fashion... > > Thanks in advance for any pointers/ideas/suggestions. > > Regards, > > Roberto Perez > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232194 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
