From 2d6a24ff676a930e6db9726b0c0c20253759fa72 Mon Sep 17 00:00:00 2001
From: Kyle M Hall <kyle@bywatersolutions.com>
Date: Tue, 26 Feb 2013 10:34:20 -0500
Subject: [PATCH] Bug 9458 - Add sorting to lists - QA Followup 2

Signed-off-by: Jared Camins-Esakov <jcamins@cpbibliography.com>
(cherry picked from commit be48d34b4f1407178e7f3cddf45721a96025f833)

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
(cherry picked from commit be48d34b4f1407178e7f3cddf45721a96025f833)
---
 C4/VirtualShelves.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/VirtualShelves.pm b/C4/VirtualShelves.pm
index 46884169c0..1b989962ce 100644
--- a/C4/VirtualShelves.pm
+++ b/C4/VirtualShelves.pm
@@ -275,7 +275,7 @@ sub GetShelfContents {
          WHERE  vc.shelfnumber=? ";
     my @params = ($shelfnumber);
     if($sortfield) {
-        $query .= " ORDER BY " . $sortfield;
+        $query .= " ORDER BY " . $dbh->quote_identifier( $sortfield );
         $query .= " DESC " if ( $sort_direction eq 'desc' );
     }
     if($row_count){
-- 
2.39.5