[TYPO3-mvc] Prepared statement with variable num of arguments?

Marc Wöhlken woehlken at quadracom.de
Fri Oct 25 16:42:53 CEST 2013


Thanks for the explanation.

Am 25.10.2013 13:58, schrieb Xavier Perseguers:

> The original preparedstatement introduced in TYPO3 4.5 let you separate
> the SQL definition and the execution with a given set of "values":
> 
> http://buzz.typo3.org/teams/core/article/typo3-45-lts-prepared-queries-are-the-way-to-go/

Ooops, my original posting contained an error. $query->statement() is
completely capable of handling values within an array.

The following DOES work:
// $values would be an array, $sql a string
$query->statement($sql,$values);


Had a problem within the sql which caused the query to return no results :-(

Sorry
	Marc

-- 
...........................................................
Marc Wöhlken                     TYPO3 certified integrator

Quadracom - Proffe & Wöhlken

Rembertistraße 32              WWW: http://www.quadracom.de
D-28203 Bremen                E-Mail: woehlken at quadracom.de
______________             PGP-Key: http://pgp.quadracom.de


More information about the TYPO3-project-typo3v4mvc mailing list