Hi,
Does anyone have an idea why the following code does not set the column slip_id to NULL for all records where slip_id is equal to 7?
my $trans = $DB->table( "transactions" );
$trans->update( {'slip_id'=>undef}, GT::SQL::Condition->new('slip_id', '=', 7 ) );Note that the following code does work:
$trans->update( {'slip_id'=>0}, GT::SQL::Condition->new('slip_id', '=', 7 ) );
Thanks, Jasper
http://www.bookings.org
Does anyone have an idea why the following code does not set the column slip_id to NULL for all records where slip_id is equal to 7?
Code:
my $trans = $DB->table( "transactions" );
$trans->update( {'slip_id'=>undef}, GT::SQL::Condition->new('slip_id', '=', 7 ) );
Code:
my $trans = $DB->table( "transactions" ); $trans->update( {'slip_id'=>0}, GT::SQL::Condition->new('slip_id', '=', 7 ) );
Thanks, Jasper
http://www.bookings.org