Robertson-Ravo, Neil (RX) wrote: > I'm running into some of the very problems you mention. > I tried "Decimal" as the field type, but 100.5 gets rounded up to > 101.00...not good. > > I tried Integer, but when, for example, 100.50 gets entered into a > formfield, > then inserted into the db, it gets truncated to 100. How do I set up > Integer > to retain 2 decimal places? > > <cfqueryparam cfsqltype="CF_SQL_INTEGER" > Value="#LSCurrentFormat(LSParseNumber(Form.UCPaymentAmount))#">
<CFQUERYPARAM value="100.5" CFSQLType="CF_SQL_DECIMAL" scale="2"> integers are whole numbers and you need to specific how many decimal points using scale as above... z ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm