Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re^2: DBI SQL Returns Less than Direct SQL

by DaveNagy (Initiate)
on Oct 18, 2011 at 15:33 UTC ( #932176=note: print w/replies, xml ) Need Help??

in reply to Re: DBI SQL Returns Less than Direct SQL
in thread SOLVED: DBI SQL Returns Less than Direct SQL

True! But, this count matches the rows returned in results arrays, whether as the result of an EXECUTE or other method.

The documentation cautions that getting a count of rows might not work for certain drivers but doesn't explicitly say that for MySQL the results are not guaranteed. I had this code after the loop where I processed the results and the row count matches the number of rows returned in arrays (and for other search words, I do get more than 1 row but always less than shown in pure SQL via PHPAdmin and other query processes.)

Thanks, Dave
  • Comment on Re^2: DBI SQL Returns Less than Direct SQL

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://932176]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (6)
As of 2018-05-27 08:46 GMT
Find Nodes?
    Voting Booth?