From ca7bec7639f2157ee62635238c9a420371dd1fce Mon Sep 17 00:00:00 2001
From: sergerenaux <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\n<META HTTP-EQUIV=Refresh CONTENT=\"0; URL=authorised_values.pl?searchfield=".$input->param('category')."\"></html>";
 	exit;
-- 
2.39.2