SqlBuilder.class.php #2

Hi Kris,

I've just found another BUG ('cause i am full time using you framework here ;) When using a column of type Float, the query builder renders my_column = 1.1 where it has to render my_column LIKE 1.1 (at least in MySQL). Look the code bellow:

protected function whereHelper() {
		$sql = '';
		
		$first = true;
		if(!empty($this->conditions)) {
			foreach($this->conditions as $clause) {
				if(!$first) { $sql .= ' AND '; } else { $first = false; } // TODO: Figure out how we'll do ORing
				$sql .= $clause->column . ' ' . $clause->operator . ' ' . $clause->getQueryParameter();
			}
		}
		
		if($this->useAssignmentsAsConditions && !empty($this->assignments)) {
			$assignments = $this->cleansedAssignmentsAsConditions();
			foreach($assignments as $clause) {
				if(!$first) { $sql .= ' AND '; } else { $first = false; } // TODO: Figure out how we'll do ORing
				//$sql .= $clause->column . ' **=** ' . $clause->getQueryParameter();
				$sql .= $clause->column . ' **LIKE** ' . $clause->getQueryParameter();
			}
		}
		
		if($sql != '') {
			$sql = ' WHERE ' . $sql;
		}
		
		return $sql;
	}

The code above is just a QUICK & DIRTY fix so i can continue with my development.