> table. Now, the problem is, that when some variables are undefined in this
> %hash, but they exist in table, then Update sets them to 'undef' in table
> too and I don't like it.
>
Just delet them from the data hash:
foreach (keys %$data)
{
delete $data -> {$_} if (!defined ($data -> {$_})) ;
}
>
> $db->Update( $data, $where );
>
then they won't get set to NULL in the database
Gerald
-------------------------------------------------------------
Gerald Richter ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting
Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz
E-Mail: [EMAIL PROTECTED] Voice: +49 6133 925131
WWW: http://www.ecos.de Fax: +49 6133 925152
-------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
