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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]