Hi,
Nuno Oliveira wrote:
When I set the RS.Source to the first SELECT statement and open it, it
run OK but I need to close the RS and open it again using the second
SELECT statement.
After any of this operations I get a Recordset->RecordsCount = 1
That is actually a correct figure, SELECT FOUND_ROWS() returns exactly
one record *CONTAINING* the number of found rows. So you have to access
the resultset to get the actual number of rows. SELECT
SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by
the way.
regards
Nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
