[ciapug] Adodb: RecordCount()

[Chris Hettinger]

In answer to this I am doing this against ms-sql and RecordCount does =
work.

-----Original Message-----
From: David Champion [mailto:dave@visionary.com]
Sent: Friday, October 24, 2003 1:20 PM
To: ciapug@cialug.org
Subject: Re: [ciapug] Adodb: RecordCount()


Chris Hettinger wrote:

> Replied to quickly...=20
>=20
>  $sql =3D "SELECT * FROM states";
>  $results =3D $db->Execute($sql);
>  // returns 50 records
>=20
>  $count =3D $results->RecordCount();
>  echo $count;
>=20
> 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=20
Oracle. Others that are "spotty" are things like MoveFirst() - or=20
anything that moves the cursor position anything more than forward one.

-dc


_______________________________________________
ciapug mailing list
ciapug@cialug.org
http://cialug.org/mailman/listinfo/ciapug


CONFIDENTIALITY NOTICE:  This communication, including any attachment, =
may contain confidential information and is intended only for the =
individual or entity to whom it is addressed.  Any review, =
dissemination, or copying of this communication by anyone other than the =
intended recipient is strictly prohibited.  If you are not the intended =
recipient, please contact the sender by reply email, delete and destroy =
all copies of the original message.'