SQL_CALC_FOUND_ROWS and FOUND_ROWS
Posted: 26.11.2005, 23:06
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
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