Subversion-Projekte lars-tiefland.ci

Revision

Revision 2257 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 2257 Revision 2258
Zeile 968... Zeile 968...
968
			{
968
			{
969
				case 'none':
969
				case 'none':
970
					$v = "'{$v}'";
970
					$v = "'{$v}'";
971
					break;
971
					break;
972
				case 'before':
972
				case 'before':
973
					$v = "%'{$v}'";
973
					$v = "'%{$v}'";
974
					break;
974
					break;
975
				case 'after':
975
				case 'after':
976
					$v = "'{$v}%'";
976
					$v = "'{$v}%'";
977
					break;
977
					break;
978
				case 'both':
978
				case 'both':
Zeile 985... Zeile 985...
985
			if ($escape === TRUE && $this->_like_escape_str !== '')
985
			if ($escape === TRUE && $this->_like_escape_str !== '')
986
			{
986
			{
987
				$v .= sprintf($this->_like_escape_str, $this->_like_escape_chr);
987
				$v .= sprintf($this->_like_escape_str, $this->_like_escape_chr);
988
			}
988
			}
Zeile 989... Zeile 989...
989
 
989
 
990
			$qb_where = array('condition' => "{$prefix} {$k} {$not} LIKE", 'value' => $v, 'escape' => $escape);
990
			$qb_where = array('condition' => "{$prefix} {$k} {$not} LIKE {$v}", 'value' => NULL, 'escape' => $escape);
991
			$this->qb_where[] = $qb_where;
991
			$this->qb_where[] = $qb_where;
992
			if ($this->qb_caching === TRUE)
992
			if ($this->qb_caching === TRUE)
993
			{
993
			{
994
				$this->qb_cache_where[] = $qb_where;
994
				$this->qb_cache_where[] = $qb_where;
Zeile 2213... Zeile 2213...
2213
	 * @return	string
2213
	 * @return	string
2214
	 */
2214
	 */
2215
	protected function _delete($table)
2215
	protected function _delete($table)
2216
	{
2216
	{
2217
		return 'DELETE FROM '.$table.$this->_compile_wh('qb_where')
2217
		return 'DELETE FROM '.$table.$this->_compile_wh('qb_where')
2218
			.($this->qb_limit ? ' LIMIT '.$this->qb_limit : '');
2218
			.($this->qb_limit !== FALSE ? ' LIMIT '.$this->qb_limit : '');
2219
	}
2219
	}
Zeile 2220... Zeile 2220...
2220
 
2220
 
Zeile 2221... Zeile 2221...
2221
	// --------------------------------------------------------------------
2221
	// --------------------------------------------------------------------
Zeile 2363... Zeile 2363...
2363
			.$this->_compile_group_by()
2363
			.$this->_compile_group_by()
2364
			.$this->_compile_wh('qb_having')
2364
			.$this->_compile_wh('qb_having')
2365
			.$this->_compile_order_by(); // ORDER BY
2365
			.$this->_compile_order_by(); // ORDER BY
Zeile 2366... Zeile 2366...
2366
 
2366
 
2367
		// LIMIT
2367
		// LIMIT
2368
		if ($this->qb_limit OR $this->qb_offset)
2368
		if ($this->qb_limit !== FALSE OR $this->qb_offset)
2369
		{
2369
		{
2370
			return $this->_limit($sql."\n");
2370
			return $this->_limit($sql."\n");
Zeile 2371... Zeile 2371...
2371
		}
2371
		}