Unfortunately your kind suggestions did not work

I neglected to mention that my code works beautifully if I take out ratd_Column11 and ratd_Column12 fields in the query. Those 2 fields are decimal data types and the others are varchar data types. So, I tried your suggestions with just the decimal fields and still no luck. But again, my setup works fine if I'm not trying to use columns 11 & 12. Any other thoughts?
This is my original code.....that works just fine.
Code: Select all
$field_str='';
$field_str .= " ratd_Column01= '$ratd_Column01',";
$field_str .= " ratd_Column02= '$ratd_Column02',";
$field_str .= " ratd_Column03= '$ratd_Column03',";
$field_str .= " ratd_Column04= '$ratd_Column04',";
$field_str .= " ratd_Column05= '$ratd_Column05',";
$field_str .= " ratd_Column06= '$ratd_Column06',";
$field_str .= " ratd_Column07= '$ratd_Column07',";
$field_str .= " ratd_Column08= '$ratd_Column08',";
$field_str .= " ratd_Column09= '$ratd_Column09',";
$field_str .= " ratd_Column10= '$ratd_Column10',";
If I add the following 2 lines for 11 and 12...this code doesn't work.
Code: Select all
$field_str .= " ratd_Column11= '$ratd_Column11',";
$field_str .= " ratd_Column12= '$ratd_Column12',";
$field_str .= " ratd_Notes= '$ratd_Notes' ";
$query="UPDATE Rates SET $field_str WHERE
Rates_Id='$Rates_Id'";
$result=odbc_exec($odbc_db, $query);
if(!$result) die ("Error executing query $query");
}