Query & number with comma
Posted on 2006-05-11
Hi, I'm trying to insert/update some numeric field (Oracle database)
My code looks like this:
"UPDATE myTab SET myNum = TO_NUMBER('" + Request["myNum"] + ")";
I get the error --> ORA-01722: invalid number
But, if I execute the query from SQLPlus (or other DB tools), it's successful.
As far as the query is the same, why it doesn't work from .NET? Do I miss something?
I also tried Convert.ToDouble(Request["myField"]) but it doesn't work either.