From 6191812cbe465d93cf322d64bc525d299530e4a9 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Mon, 23 Apr 2007 23:34:52 +0000
Subject: [PATCH] fix error: column reference "fieldname" is ambiguous

---
 httemplate/search/cust_pkg.cgi | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/httemplate/search/cust_pkg.cgi b/httemplate/search/cust_pkg.cgi
index 84b083a3d..4fd5e9d45 100755
--- a/httemplate/search/cust_pkg.cgi
+++ b/httemplate/search/cust_pkg.cgi
@@ -225,11 +225,11 @@ foreach my $field (qw( setup last_bill bill susp expire cancel )) {
        or $disable{$cgi->param('status')}->{$field};
 
   push @where,
-    "$field IS NOT NULL",
-    "$field >= $beginning",
-    "$field <= $ending";
+    "cust_pkg.$field IS NOT NULL",
+    "cust_pkg.$field >= $beginning",
+    "cust_pkg.$field <= $ending";
 
-  $orderby ||= "ORDER BY $field";
+  $orderby ||= "ORDER BY cust_pkg.$field";
 
 }
 
-- 
2.11.0