When i submit a request from an html form i receive the error msg unknown column, the field in question is half way thru the form. We checked for format errors such as spelling all fields are the same “” for html ” for cgi and perl scripts. When the html form is submitted it errors out whilc performing insert $dbh->do($query);

code used: my $query = “INSERT INTO $table_name ($column_names) VALUES ($column_values)”;
415         print $main::log “running $queryn”;
416         $dbh->do($query);

So at a lost sql-server table has all field written the same as well as all html,cgi,perl scripts. Yet this keeps failing to complete a write to DB!

Reviewed all scripts to verify all fields are the same from html – sql-server. I have run all scripte is question from cmd line ./prcss.cgi it runs but with unitialized errors not sure if this the source of our issues or not ./Med.pm ./Handler runs without errors. Note all these scripts ran before the coversion from maria-sqlDB to oracle like mysql. Went back and rechecked table structure found practice_address had an improperly applied index number removed and now to the next error unknown column ‘practice_city’ . Its a battle!