From 335c15d42eed557727aaa64874a52d10e0a790d3 Mon Sep 17 00:00:00 2001 From: wolfpac444 Date: Wed, 9 Apr 2003 00:32:34 +0000 Subject: [PATCH] Fixed BBug #291 --- insertdata.pl | 3 +++ 1 file changed, 3 insertions(+) diff --git a/insertdata.pl b/insertdata.pl index 1dc516aded..827b7f9500 100755 --- a/insertdata.pl +++ b/insertdata.pl @@ -49,8 +49,10 @@ my $query="Select * from borrowers where borrowernumber=$data{'borrowernumber'}" my $sth=$dbh->prepare($query); $sth->execute; if (my $data=$sth->fetchrow_hashref){ +<<<<<<< insertdata.pl $data{'dateofbirth'}=format_date_in_iso($data{'dateofbirth'}); $data{'joining'}=format_date_in_iso($data{'joining'}); + $data{'expiry'}=format_date_in_iso($data{'expiry'}); $query="update borrowers set title='$data{'title'}',expiry='$data{'expiry'}', cardnumber='$data{'cardnumber'}',sex='$data{'sex'}',ethnotes='$data{'ethnicnotes'}', streetaddress='$data{'address'}',faxnumber='$data{'faxnumber'}',firstname='$data{'firstname'}', @@ -67,6 +69,7 @@ if (my $data=$sth->fetchrow_hashref){ }else{ $data{'dateofbirth'}=format_date_in_iso($data{'dateofbirth'}); $data{'joining'}=format_date_in_iso($data{'joining'}); + $data{'expiry'}=format_date_in_iso($data{'expiry'}); $query="insert into borrowers (title,expiry,cardnumber,sex,ethnotes,streetaddress,faxnumber, firstname,altnotes,dateofbirth,contactname,emailaddress,textmessaging,dateenrolled,streetcity, altrelationship,othernames,phoneday,categorycode,city,area,phone,borrowernotes,altphone,surname, -- 2.39.5