From 69676e2af001ffd5eec980bf977cc447c11ac3a9 Mon Sep 17 00:00:00 2001
From: jeff <jeff>
Date: Thu, 4 Dec 2008 01:46:20 +0000
Subject: [PATCH] better behavior when zip code is missing

---
 httemplate/edit/cust_main/choose_tax_location.html | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/httemplate/edit/cust_main/choose_tax_location.html b/httemplate/edit/cust_main/choose_tax_location.html
index 23fdbf282..045490b55 100644
--- a/httemplate/edit/cust_main/choose_tax_location.html
+++ b/httemplate/edit/cust_main/choose_tax_location.html
@@ -50,7 +50,10 @@ my $hashref = { data_vendor => $data_vendor,
 my @keys = qw ( zip );
 my @cust_tax_location = ();
 until ( @cust_tax_location ) {
-  @cust_tax_location = qsearch( 'cust_tax_location', $hashref );
+  @cust_tax_location = qsearch({ table    => 'cust_tax_location',
+                                 hashref  =>  $hashref,
+                                 order_by =>  'LIMIT 50',
+                              });
   last unless scalar(@keys);
   delete $hashref->{ shift @keys };
 } 
-- 
2.11.0