[TYPO3-core] RFC: Bug #10099: Use TYPO3_DB->exec_SELECTcountRows() to determine the number of rows

Dmitry Dulepov dmitry at typo3.org
Mon Jan 12 16:16:35 CET 2009


Hi!

Oliver Hader wrote:
> In the TYPO Core counting rows is/was implemented as the following:
> * get result set for a "COUNT(*)" query, fetch row, free result set (not
> in all cases)
> * get result set for a regular table SELECT, get sql_num_rows, free
> result set (not in all cases again)
> 
> Solution:
> To prevent hanging record sets here and simplify the code,
> TYPO3_DB->exec_SELECTcountRows() is going to be used.

Some of the calls use '*'. others use 'uid'. Is there any special reason for such differences?

-- 
Dmitry Dulepov
TYPO3 core team

Mr. Harris: People say that you were the last person to speak with Jordon...
            Is that true? 
Cameron: I don't know. Are you asking me if people say I was the last person
            to talk to Jordon? Or are you asking me if I was the last person
            to talk to her? 
Mr. Harris: I guess I'm asking if you were. 
Cameron: I don't know. 


More information about the TYPO3-team-core mailing list