Page 1 of 1

SQL_CALC_FOUND_ROWS and FOUND_ROWS

Posted: 26.11.2005, 23:06
by mpap
Hello,

i need your help.
I send via TQuery component sql command
SELECT SQL_CALC_FOUND_ROWS * from X limit 1,10;
where X is table in mysql v4.1.This operation is successfully completed.

I need send next sql command
SELECT FOUND_ROWS();
and obtain count of records from table (not from resultset).

What class or object from Zeoslib realize FOUND_ROWS() function?
Please send me small example.
Thank you for help.
Milos