From 80942a30310e2bb39775b9e5d3d709abef76767a Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 17 Dec 2007 12:42:03 -0600 Subject: [PATCH] fixed reference to branchrelations.categorycode Previous patch had referred to column as category_id, which is incorrect. Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- C4/Branch.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Branch.pm b/C4/Branch.pm index a13af59ef4..833c7727ea 100644 --- a/C4/Branch.pm +++ b/C4/Branch.pm @@ -111,7 +111,7 @@ sub GetBranches { while ( my $branch = $sth->fetchrow_hashref ) { my $nsth = $dbh->prepare( - "SELECT category_id FROM branchrelations WHERE branchcode = ?"); + "SELECT categorycode FROM branchrelations WHERE branchcode = ?"); $nsth->execute( $branch->{'branchcode'} ); while ( my ($cat) = $nsth->fetchrow_array ) { -- 2.39.5