Allow subqueries of strings in remote API.

tbrehm

2012-01-12 bb0c7702e7f2698aa73c94c891e74ef7d97e5e97

 interface/lib/classes/remoting_lib.inc.php

@@ -208,7 +208,13 @@
                                break;

                                case 'INTEGER':
                                        $new_record[$key] = intval($record[$key]);
                              //* We use + 0 to force the string to be a number as 
                              //* intval return value is too limited on 32bit systems
                                        if(intval($record[$key]) == 2147483647) {
                                 $new_record[$key] = $record[$key] + 0;
                              } else {
                                 $new_record[$key] = intval($record[$key]);
                              }
                                break;

                                case 'DOUBLE':
@@ -639,7 +645,11 @@
            foreach($primary_id as $key => $val) {
               $key = $app->db->quote($key);
               $val = $app->db->quote($val);
               $sql_where .= "$key = '$val' AND ";
               if(strpos($val,'%')) {
                  $sql_where .= "$key like '$val' AND ";
               } else {
                  $sql_where .= "$key = '$val' AND ";
               }
            }
            $sql_where = substr($sql_where,0,-5);
            $sql = "SELECT * FROM ".$escape.$this->formDef['db_table'].$escape." WHERE ".$sql_where;