Re: Pear::db and odbc issue

On Wed, 20 Nov 2002, Chandler, Jacob R wrote: > We are querying two different odbc databases using the Pear::DB library. > When we try to print out the number of Rows ($result->numRows()), the > output is 'Object'. We tried the same thing using odbc and we are > getting '-1' as the number of rows. This appears to be an error because > there are results in the database and if we attempt to get data, we can > do this in a while loop with the fetchRow function and we get valid > data. Can anyone give any suggestions? Try var_dump()ing the object you get from numRows(), it could be a PEAR error object. In general numRows is not something you can rely on, at least not if you want your code to be portable to other databases. - Stig