[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