$textanswer->update won't update anything unless you've actually changed something inside of your $textanswer object.

Aside from that - Class::DBI hasn't seen much action lately. You may benefit from using DBIx::Class (completely new) or Class::DBI::Lite (more similar to Class::DBI).

Disclaimer: I am the author of Class::DBI::Lite.