From 2ccb5471188aae2f3ade7096d155b3d8f474113a Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 20 Mar 2008 17:32:14 -0500 Subject: [PATCH] partial fix for bug 1417 The Notes field should now be displayed correctly when editing an order - the query in GetOrder was modified to have aqorder's notes column appear last, which means that it is the one selected for the data hash (instead of biblio.notes or biblioitems.notes). This is an ugly fix - GetOrder needs to be refactored so that it doesn't depend on selecting all columns from several different tables. Signed-off-by: Joshua Ferraro --- C4/Acquisition.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index bedde62025..35735c0b5f 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -345,7 +345,7 @@ sub GetOrder { my ($ordnum) = @_; my $dbh = C4::Context->dbh; my $query = " - SELECT * + SELECT biblioitems.*, biblio.*, aqorderbreakdown.*, aqorders.* FROM aqorders LEFT JOIN aqorderbreakdown ON aqorders.ordernumber=aqorderbreakdown.ordernumber LEFT JOIN biblio on biblio.biblionumber=aqorders.biblionumber -- 2.39.5