Updating a field value in database via submit handler doesn't update the user profile in UI I've created the field "Attending" that is attached to the user profile.
I have created a form with one checkbox element; when submitted, I've confirmed that the attending_fielddatabase is being updated with the current value (0 or 1), but when I view the user profile through the UI, the updated value isn't being displayed.

The submit handler I am using is the following:

function rsvp_aform_submit($form, &amp;$form_state) {
  global $user;
  db_query("UPDATE {field_data_field_attending} SET field_attending_value = :val WHERE entity_id = :eid", array(':val' =&gt; $form_state['values']['rsvp'], ':eid' =&gt; $user-&gt;uid));
  drupal_set_message(t('Your form has been saved.'));
}


Do you have any idea?
I think that's the caching. First try to clear the cache manually. If that helps you should use cache_clear_all() to clear the corresponding cache tables (e.g. cache_content, cache_views_data) after you update the db.