nm. its the out put they where using dollar format on the value wether or not the value was enterd that way.
On Tue, Mar 30, 2010 at 8:32 AM, Dorioo <dor...@gmail.com> wrote: > > 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 <pih...@gmail.com> 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:332431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm