SQL_CALC_FOUND_ROWS and FOUND_ROWS

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
mpap
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 06.11.2005, 18:56

SQL_CALC_FOUND_ROWS and FOUND_ROWS

Post 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
Post Reply