Here is a weird one that I absolutely cannot figure out. On our development system, I have a form where I insert 0.00 into a field name value_amount. This field has not be accessed yet.
Later on, in another form, I have <input type="text" name="value_amount" value="0.00"> and when they submit I do a update table, and
set value_amount = '#form.value_amount#'. So the value amount initially in the table is 0 and I want to update it to what they put in, for example 19.99.
I now get an error and when I do cfoutput to display the values, it shows form.value_amount as 19.99,0.00.
Why is it not updating and replacing 0.00 with 19.99 ?
On the production system it works but on our developement system I get this error. I am redesigning the form on the dev system and one difference is the cftransadtion tag around the update query in the dev system but that should not make a difference.
I even copied the exact same code over and the tables in dev and prod are identical.
What else could be the problem and what else should I be looking for ?
1
Reply
AdChoices