From ca7bec7639f2157ee62635238c9a420371dd1fce Mon Sep 17 00:00:00 2001 From: sergerenaux Date: Tue, 17 Jun 2003 09:30:56 +0000 Subject: [PATCH] *** empty log message *** --- admin/authorised_values.pl | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/admin/authorised_values.pl b/admin/authorised_values.pl index 4adeae10fc..158935724a 100755 --- a/admin/authorised_values.pl +++ b/admin/authorised_values.pl @@ -110,7 +110,10 @@ if ($op eq 'add_form') { } elsif ($op eq 'add_validate') { my $dbh = C4::Context->dbh; my $sth=$dbh->prepare("replace authorised_values (id,category,authorised_value,lib) values (?,?,?,?)"); - $sth->execute($input->param('id'), $input->param('category'), $input->param('authorised_value'),$input->param('lib')); + my $lib = $input->param('lib'); + undef $lib if ($lib eq ""); # to insert NULL instead of a blank string + + $sth->execute($input->param('id'), $input->param('category'), $input->param('authorised_value'), $lib); $sth->finish; print "Content-Type: text/html\n\nparam('category')."\">"; exit; -- 2.39.5