Hello, experts out there. First of all, thanks for reading my threads.

I am a junior developer using ColdFusion. I have some doubts here.

When we passing the parameters which is numeric type, then use that variable in another page for query, sometimes will come out with error of CF_SQL_NUMERIC, even we just #trim(variable)#.

When i meet such problem, i always #val(variable)# in order to get back the numeric value. It works if the variable when i have full confidence the variable is a numeric type. But is this the proper way to fix this?? Or anyone can tell me the correct way and the impact by #val()# the variable??


Thanks for help. :mrgreen: