Re: SQL_CALC_FOUND_ROWS using ODBC driver

On Thu, Feb 15, 2007 at 01:04:26AM +0000, Nuno Oliveira wrote:
> Hi,
> 
> I've used PHP with MySQL and I was able to count the rows of a table by 
> using the following code:
> 
> SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName;
> SELECT FOUND_ROWS();
> 
> However, I would like to do the same thing using Visual Basic 6...
> 
> 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
> 
> How can I work this out?

Since you are asking for the row count from the database and not the
driver, you have to treat it like a normal result. So rs.Fields(1)
should contain the row count.

Jess

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx