-------------------------------------------- PTMDB MODULE - db_update_row_hash() FUNCTION -------------------------------------------- ------------ USAGE FORMAT ------------ Where $ret is a return value of 1 or 0 (zero): $ret = &db_update_row_hash($db_object, $table, $column, $value, \%column_value_pairs); $ret = &db_update_row_hash($db_object, $table, $column, $value, {$col1=>$val1, $col2=>$val2}); ----------- DESCRIPTION ----------- Updates a given database table row where $column = $value. The intended use of this function is to allow updating a row with only certain column fields filled in without having to define every field. Returns 1 if successful Returns 0 (zero) if not successful --------- ARGUMENTS --------- $db_object REQUIRED A database handler object. This object stores connection information and is returned from a db_connect() function call. This object is of the same type as is returned by a DBI->connect function call. $table REQUIRED The name of the table in which you would like to update row information. $column REQUIRED The column name to use in a `column` = 'value' test comparison. $value REQUIRED The value to use in a `column` = 'value' test comparison. \%column_value_pairs REQUIRED A hash reference containing the reqested field column => value quantifier pairs. This may be either a direct hash reference or an inline Perl hash reference defined in {$column => $value} format. ------- RETURNS ------- 1 if row was updated successfully 0 (zero) if row was not updated successfully or no row matches were found. -------------- USAGE EXAMPLES -------------- ------------------------------------------------------------------------- Example 1: Update a Row in 'MyTable' Where 'id' is '10' with a New 'name' ------------------------------------------------------------------------- 'John'}); ?> -------- SEE ALSO -------- MODULES PTMDB FUNCTIONS PTMDB - db_connect() PTMDB - db_update_row() PTMDB - db_update_row_hash_like() PTMDB - db_update_row_hash_where()