[ciapug] Adodb: RecordCount()

David Champion ciapug@cialug.org
Fri, 24 Oct 2003 13:19:37 -0500


Chris Hettinger wrote:

> Replied to quickly... 
> 
>  $sql = "SELECT * FROM states";
>  $results = $db->Execute($sql);
>  // returns 50 records
> 
>  $count = $results->RecordCount();
>  echo $count;
> 
> This is showing 0. *hrmm*

Is this on mysql or ms-sql? Some of ADODB's methods don't work with some 
  databases. For instance, the Identity_Insert() doesn't work with 
Oracle. Others that are "spotty" are things like MoveFirst() - or 
anything that moves the cursor position anything more than forward one.

-dc