Re: [sqlite] numRows undefined function?

2008-05-01 Thread Ty ...
On Wed, Apr 30, 2008 at 4:50 PM, Skip Evans <[EMAIL PROTECTED]> wrote: > But why did so much documentation I found on the > web use numRows()? > > What is the difference between the PDOStatement > set of functions and the set to which numRows() > belongs to? > > Different versions of SQLite?

Re: [sqlite] numRows undefined function?

2008-04-30 Thread Skip Evans
Hey Ty & all, Yes, rowCount() worked, and thanks for the reference to the podstatement.php page. But why did so much documentation I found on the web use numRows()? What is the difference between the PDOStatement set of functions and the set to which numRows() belongs to? Different versions

Re: [sqlite] numRows undefined function?

2008-04-30 Thread Ty
Skip Evans <[EMAIL PROTECTED]> writes: > But when it runs I get the following error: > > Call to undefined method PDOStatement::numRows() > > All the documentation I see on SQLite shows this > as a valid method. If I'm reading correctly, $result is of type PDOStatement. From the documentat

[sqlite] numRows undefined function?

2008-04-30 Thread Skip Evans
Hey all, I'm new to the list and SQLite, although I have about 7 years with MySQL, and going back to Oracle and Informix a rock's age with databases. I have the following code in a PHP 5.2.5 install. $sql="SELECT * FROM bsp_model WHERE makeID=$makeID ORDER BY model"; $result = $dbHandle->quer

Re: [sqlite] numrows

2004-05-29 Thread nathanvi
Il giorno Wed, 26 May 2004 09:20:24 -0400 (EDT), tu oh prode "H. Wade Minter" <[EMAIL PROTECTED]> hai scritto una mail. Il suo oggetto era"[sqlite] numrows": > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > [Apologies if this goes to the list twice

Re: [sqlite] numrows

2004-05-26 Thread H. Wade Minter
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 26 May 2004, Randy J. Ray wrote: From the DBI manpage: "rows" $rv = $sth->rows; Returns the number of rows affected by the last row affecting com- mand, or -1 if the number of rows is not known or not availa

Re: [sqlite] numrows

2004-05-26 Thread Randy J. Ray
H. Wade Minter wrote: In DBD::SQLite, what's the proper way to get the number of rows returned by a query? for example: $query = "SELECT * FROM foo WHERE bar LIKE '%baz%'"; $sth = $dbh->prepare($query); $sth->execute; $numrows = $sth->rows; # DOES NOT WORK, ALWAYS RETURNS -1 From the DBI manpage:

[sqlite] numrows

2004-05-26 Thread H. Wade Minter
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [Apologies if this goes to the list twice - I had email issues last night and couldn't tell if it went through] In DBD::SQLite, what's the proper way to get the number of rows returned by a query? for example: $query = "SELECT * FROM foo WHERE bar LI