[TYPO3-core] RFC #15457: Add support for prepared queries [summary and pending questions]

Helmut Hummel helmut at typo3.org
Fri Aug 20 09:06:31 CEST 2010


Hi,

On 20.08.10 08:00, Xavier Perseguers wrote:
> 
>> Thanks for the great work on that.
>>
>> While writing unit tests for the new preparedStatement class, I found a
>> bug. Named parameters will not get replaced, if passed to execute().
>>
>> Find the fix attached.
> 
> I'll have a look at that but it's actually not a bug, it's documented as 
> this in the phpDoc ;-)

Uh, well, I do not remember that that was changed, since your test
example had that feature:

> sample #1 (named parameter)
> ====================================
> $statement = $GLOBALS['TYPO3_DB']->prepare_SELECTquery('*', 'pages',
> 'pid = :pid');
> $statement->execute(array(':uid' => 2));
> while (($row = $statement->fetch()) !== FALSE) {
> 	// ...
> }
> $statement->free();

Since you and me intutively expected this to be possible, we probably
should implement it ;)

I see no problem having this in place, do you?

Regards Helmut


More information about the TYPO3-team-core mailing list