From 7a64671da10ec1e5d04a227cb7f37a914204d039 Mon Sep 17 00:00:00 2001 From: rangi Date: Tue, 9 Apr 2002 00:04:39 +0000 Subject: [PATCH] Just a quick little fix the sql to update a borrower was setting the postal address twice, instead of the postal, then the physical address. My little fix got overwrote by pat's fix so im updating now before i forget :) --- insertdata.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/insertdata.pl b/insertdata.pl index d69fdc6001..b88f3f96b5 100755 --- a/insertdata.pl +++ b/insertdata.pl @@ -40,7 +40,7 @@ if (my $data=$sth->fetchrow_hashref){ altrelationship='$data{'altrelationship'}',othernames='$data{'othernames'}',phoneday='$data{'phoneday'}', categorycode='$data{'categorycode'}',city='$data{'city'}',area='$data{'area'}',phone='$data{'phone'}', borrowernotes='$data{'borrowernotes'}',altphone='$data{'altphone'}',surname='$data{'surname'}', - initials='$data{'initials'}',streetaddress='$data{'address'}',ethnicity='$data{'ethnicity'}', + initials='$data{'initials'}',physstreet='$data{'address'}',ethnicity='$data{'ethnicity'}', gonenoaddress='$data{'gna'}',lost='$data{'lost'}',debarred='$data{'debarred'}' where borrowernumber=$data{'borrowernumber'}"; # print $query; -- 2.39.5