[TYPO3-core] RFC #11916: Feature: New TYPO3_DB method for queries that expect just a single result row

[Steffen Kamper]

Hi,

Ernesto Baschny [cron IT] schrieb:
> JoH asenau schrieb am 14.11.2010 16:24:
>>>> comment for $numIndex was wrong. Attached is v3 which fixes this.
>>> +1 by reading with two questions/remarks:
>>> 1. The debug line could be copied from exec_SELECTgetRows() (three
>>> lines with {})
>>> 2. if $output is initialized outside the if (!$this->sql_error()), how
>>> can I distinguish between an empty result set and an error? (if
>>> exec_SELECTgetRows() returns NULL something must have gone wrong)
>> Attached is v4 which fixes the issues.
>>
>> Thx for the reviews
> 
> If there is an error in the SQL, why not throw an exception? This is a
> new method and we are not bound to follow the "old principles", just
> because other methods do some hackish way.
> 
> So that new method should either return an array or it will throw an
> exception, which the caller could catch or if not catched, the developer
> will see a nice stack trace.
> 

there is a call exec_SELECTquery inside so the debug will be thrown on 
error.

vg Steffen