public function GetFieldValueAsSQL($fieldInfo, $value) { if ($fieldInfo->FieldType == ftBlob) { if (is_array($value)) { return '\'' . pg_escape_bytea(file_get_contents($value[0])) . '\''; } else { return '\'' . pg_escape_bytea($value) . '\''; } } else { return parent::GetFieldValueAsSQL($fieldInfo, $value); } }
private function GetFieldValueAsSQL($fieldName, $value) { $fieldType = $this->fields[$fieldName]; return $this->commandImp->GetFieldValueAsSQL(new FieldInfo('', $fieldName, $fieldType, ''), $value); }
/** * @param BetweenFieldFilter $filter * @return void */ public function VisitBetweenFieldFilter($filter) { $this->resultCondition = sprintf('(%s BETWEEN %s AND %s)', $this->engCommandImp->GetFieldFullName($this->field), $this->engCommandImp->GetFieldValueAsSQL($this->field, $filter->GetStartValue()), $this->engCommandImp->GetFieldValueAsSQL($this->field, $filter->GetEndValue())); }
public function GetFieldValueAsSQL($fieldInfo, $value) { if ($fieldInfo->FieldType == ftBoolean) { if (!is_numeric($value) || !($value == 0 || $value == 1)) { RaiseError("The only valid values for the column {$fieldInfo->Name} are 0 and 1."); } return $this->EscapeString($value); } else { return parent::GetFieldValueAsSQL($fieldInfo, $value); } }
public function GetFieldValueAsSQL($fieldInfo, $value) { if ($fieldInfo->FieldType == ftString) { return "N" . parent::GetFieldValueAsSQL($fieldInfo, $value); } else { return parent::GetFieldValueAsSQL($fieldInfo, $value); } }