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 (file)
index 44d4de7..0000000
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 (file)
index d785784..0000000
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 (file)
index 451a985..0000000
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 (file)
index 547a79e..0000000
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 (file)
index a65bb27..0000000
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 (file)
index 8d46a28..0000000
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 54e55de..6ae5031 100644 (file)
--- 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'
   ";