in reply to DBI and UPDATE

What you have down for the update should work fine. I know you may have excluded some things for the example, but make sure you are checking for errors in the prepare and execute.