Are you certain your database column is a string and not numeric? It looks like it's taking everything before the comma and turning into a number.
- Gabriel On Tue, Mar 30, 2010 at 8:26 AM, Paul Ihrig <[email protected]> wrote: > > <cfqueryparam value = "#arguments.dollar_value#" cfsqltype = > "cf_sql_varchar">, > > if i enter value 100,000 the result is 100.00 > but if i enter 100000 OR 100000.00 it is fine? > > what gives and how do i prevent it? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
