From: Ivan Kohler <ivan@freeside.biz>
Date: Wed, 16 Jul 2014 13:19:03 +0000 (-0700)
Subject: REST API, RT#28181
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=b01ee3e9d7061a1b3b4887980b0542371be9bcd8

REST API, RT#28181
---

diff --git a/httemplate/REST/1.0/.cust_bill.swp b/httemplate/REST/1.0/.cust_bill.swp
deleted file mode 100644
index 44d4de7a9..000000000
Binary files a/httemplate/REST/1.0/.cust_bill.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/.cust_main.swp b/httemplate/REST/1.0/.cust_main.swp
deleted file mode 100644
index d785784d3..000000000
Binary files a/httemplate/REST/1.0/.cust_main.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/.cust_pkg.swp b/httemplate/REST/1.0/.cust_pkg.swp
deleted file mode 100644
index 451a98554..000000000
Binary files a/httemplate/REST/1.0/.cust_pkg.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/.part_pkg.swp b/httemplate/REST/1.0/.part_pkg.swp
deleted file mode 100644
index 547a79eee..000000000
Binary files a/httemplate/REST/1.0/.part_pkg.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/.phone_avail.swp b/httemplate/REST/1.0/.phone_avail.swp
deleted file mode 100644
index a65bb2748..000000000
Binary files a/httemplate/REST/1.0/.phone_avail.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/.rate_detail.swp b/httemplate/REST/1.0/.rate_detail.swp
deleted file mode 100644
index 8d46a280f..000000000
Binary files a/httemplate/REST/1.0/.rate_detail.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/rate_detail b/httemplate/REST/1.0/rate_detail
index 54e55de6c..6ae503190 100644
--- a/httemplate/REST/1.0/rate_detail
+++ b/httemplate/REST/1.0/rate_detail
@@ -7,7 +7,7 @@ my $extra_sql = '';
 if ( $cgi->param('countrycode') =~ /^\+?(\d+)$/ ) {
   my $countrycode = $1;
   $extra_sql = "
-    WHERE EXISTS ( SELECT 1 rate_region
+    WHERE EXISTS ( SELECT 1 FROM rate_region
                      WHERE rate_detail.dest_regionnum = rate_region.regionnum
                        AND countrycode = '$countrycode'
   ";