From 0f64d6ade7185677441bce627a25221fe293e9fd Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Tue, 8 Jan 2008 19:41:22 -0600 Subject: [PATCH] Removing replace from admin/roadtype.pl Bug 1546 Signed-off-by: Joshua Ferraro --- admin/roadtype.pl | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/admin/roadtype.pl b/admin/roadtype.pl index 12d6e75c14..85148cc54f 100755 --- a/admin/roadtype.pl +++ b/admin/roadtype.pl @@ -89,16 +89,16 @@ if ($op eq 'add_form') { my $sth; if ($input->param('roadtypeid') ){ - $sth=$dbh->prepare("replace roadtype (roadtypeid,road_type) values (?,?) "); - $sth->execute(map { $input->param($_) } ('roadtypeid','road_type')); + $sth=$dbh->prepare("UPDATE roadtype SET road_type=? WHERE roadtypeid=?"); + $sth->execute($input->param('roadtypeid'),$input->param('road_type')); } else{ - $sth=$dbh->prepare("replace roadtype (road_type) values (?)"); - $sth->execute(map { $input->param($_) } ('road_type')); + $sth=$dbh->prepare("INSERT INTO roadtype (road_type) VALUES (?)"); + $sth->execute($input->param('road_type')); } $sth->finish; - print "Content-Type: text/html\n\n"; + print $input->redirect("/cgi-bin/koha/admin/roadtype.pl"); exit; # END $OP eq ADD_VALIDATE @@ -160,4 +160,4 @@ if ($op eq 'add_form') { } #---- END $OP eq DEFAULT -output_html_with_http_headers $input, $cookie, $template->output; \ No newline at end of file +output_html_with_http_headers $input, $cookie, $template->output; -- 2.39.5