From 990a952a3d9aec0143086f8eb31504d71b49e412 Mon Sep 17 00:00:00 2001 From: Mark Gavillet Date: Wed, 6 Apr 2011 11:19:21 +0100 Subject: [PATCH] Bug: 5547 - corrected insert to database Inserting a new category failed because only 10 bind variables were present and 11 were required. --- admin/categorie.pl | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/admin/categorie.pl b/admin/categorie.pl index d0211fd..576d7ca 100755 --- a/admin/categorie.pl +++ b/admin/categorie.pl @@ -133,7 +133,7 @@ if ($op eq 'add_form') { $sth->execute(map { $input->param($_) } ('description','enrolmentperiod','enrolmentperioddate','upperagelimit','dateofbirthrequired','enrolmentfee','reservefee','hidelostitems','overduenoticerequired','category_type','categorycode')); $sth->finish; } else { - my $sth=$dbh->prepare("INSERT INTO categories (categorycode,description,enrolmentperiod,enrolmentperioddate,upperagelimit,dateofbirthrequired,enrolmentfee,reservefee,hidelostitems,overduenoticerequired,category_type) values (?,?,?,?,?,?,?,?,?,?)"); + my $sth=$dbh->prepare("INSERT INTO categories (categorycode,description,enrolmentperiod,enrolmentperioddate,upperagelimit,dateofbirthrequired,enrolmentfee,reservefee,hidelostitems,overduenoticerequired,category_type) values (?,?,?,?,?,?,?,?,?,?,?)"); $sth->execute(map { $input->param($_) } ('categorycode','description','enrolmentperiod','enrolmentperioddate','upperagelimit','dateofbirthrequired','enrolmentfee','reservefee','hidelostitems','overduenoticerequired','category_type')); $sth->finish; } -- 1.5.6.5