[FLOW3-general] statement method (sql query)

Phallin Hor phallin at web-essentials.asia
Thu Sep 6 06:56:17 CEST 2012


Dear all,

Now I'm working with query statement in FLOW3. I want to select 
customers group by name. I have used statement method. However, I got an 
error :

Fatal error: Call to undefined method 
TYPO3\FLOW3\Persistence\Doctrine\Query::statement()...

My function in repository is:
	public function findCustomerGroupByName() {
		$query = $this->createQuery();
		$query->matching(
			$query->statement('SELECT * FROM  employees GROUP BY name')
		);
		return $query->execute();
	}

And I also try

public function findCustomerGroupByName() {
		$query = $this->createQuery();
		$query->statement('SELECT * FROM  employees GROUP BY name');
		return $query->execute();
	}

Question: How can we use statement method in Flow3?

Cheer,
Phallin


More information about the FLOW3-general mailing list