Issue Feature Closed

#19786Integrate TYPO3_DB->exec_SELECTcountRows()

Oliver Hader 01/10/09, 15:28 updated 08/06/10, 13:23

Description

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)

To simplify this, it would be nice, to have an accordant method in the database API that takes care of counting rows.

There was a discussion in the dev-list some months ago and Masi had the idea to introduce such a function in TYPO3_DB, read the thread here:
http://support.typo3.org/general/dev/m/typo3-dev-tip-use-sql-function-count-354264/p/234/

(issue imported from #M10091)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.