}
function generate_sql($tablealias, $value) {
+ global $DB;
+
static $i=0;
$i++;
$name1 = "df_latlong1_$i";
$name2 = "df_latlong2_$i";
+ $varcharlat = $DB->sql_compare_text("{$tablealias}.content");
+ $varcharlong= $DB->sql_compare_text("{$tablealias}.content1");
+
$latlong[0] = '';
$latlong[1] = '';
$latlong = explode (',', $value, 2);
- return array(" ({$tablealias}.fieldid = {$this->field->id} AND {$tablealias}.content = :$name1 AND {$tablealias}.content1 = :$name2) ",
+ return array(" ({$tablealias}.fieldid = {$this->field->id} AND $varcharlat = :$name1 AND $varcharlong = :$name2) ",
array($name1=>$latlong[0], $name2=>$latlong[1]));
}
}
function generate_sql($tablealias, $value) {
+ global $DB;
+
static $i=0;
$i++;
$name = "df_menu_$i";
- return array(" ({$tablealias}.fieldid = {$this->field->id} AND {$tablealias}.content = :$name) ", array($name=>$value));
+ $varcharcontent = $DB->sql_compare_text("{$tablealias}.content", 255);
+
+ return array(" ({$tablealias}.fieldid = {$this->field->id} AND $varcharcontent = :$name) ", array($name=>$value));
}
}
}
function generate_sql($tablealias, $value) {
+ global $DB;
+
static $i=0;
$i++;
- $name = "df_number_$i";
- return array(" ({$tablealias}.fieldid = {$this->field->id} AND {$tablealias}.content = :$name) ", array($name=>$value));
+ $name = "df_radiobutton_$i";
+ $varcharcontent = $DB->sql_compare_text("{$tablealias}.content", 255);
+
+ return array(" ({$tablealias}.fieldid = {$this->field->id} AND $varcharcontent = :$name) ", array($name=>$value));
}
}
static $i=0;
$i++;
- $name = "df_picture_$i";
+ $name = "df_text_$i";
return array(" ({$tablealias}.fieldid = {$this->field->id} AND ".$DB->sql_like("{$tablealias}.content", ":$name", false).") ", array($name=>"%$value%"));
}
static $i=0;
$i++;
- $name = "df_picture_$i";
+ $name = "df_textarea_$i";
return array(" ({$tablealias}.fieldid = {$this->field->id} AND ".$DB->sql_like("{$tablealias}.content", ":$name", false).") ", array($name=>"%$value%"));
}
static $i=0;
$i++;
- $name = "df_picture_$i";
+ $name = "df_url_$i";
return array(" ({$tablealias}.fieldid = {$this->field->id} AND ".$DB->sql_like("{$tablealias}.content", ":$name", false).") ", array($name=>"%$value%"));
}