[TYPO3-mvc] How to debug query object
Søren Malling
soren.malling at gmail.com
Fri May 28 14:32:52 CEST 2010
Hi,
I'm building my own call in my repository, but I'm having some issues
with getting the wanted data in return.
One issue is, that I can't seem to find the repository in my sql log,
so i thought i would like to see the raw produced sql query, is that
possible? Or in what way should i start debugging it?
The function is this
/**
* Find members by telephone and name (for searching)
* @param string $query
*/
public function findByTelephoneAndName($seachQuery) {
$query = $this->createQuery();
$query = $query->matching(
$query->logicalOr(
$query->like('firstname', '%'.$searchQuery.'%'),
$query->like('lastname', '%'.$searchQuery.'%'),
$query->like('telephone', '%'.$searchQuery.'%')
)
)->setLimit((integer) 10);
return $query->execute();
}
I'm using revision 2271 of extbase
Regards,
Søren
--
Officially Certified TYPO3 Integrator
More information about the TYPO3-project-typo3v4mvc
mailing list