[Phplib-trackers] [ phplib-Bugs-478978 ] function affected_rows() and ODBC

[<no...@so...>]

Bugs item #478978, was opened at 2001-11-06 22:47
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=403611&aid=478978&group_id=31885

>Category: DB_SQL
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: function affected_rows() and ODBC

Initial Comment:
If you say "Many ODBC drivers don't support 
odbc_num_rows() on SELECT statements" -msaccess97 is 
one- why you use this function to set affected_rows()??
Will be better use your class function num_rows()?

----------------------------------------------------------------------

>Comment By: nathan hruby (nhruby)
Date: 2002-07-02 15:14

Message:
Logged In: YES 
user_id=19736

Err.. I don't get it?

affected_rows() returns the number of rows changed by an
UPDATE, INSERT or DELETE statement

num_rows() returns the number of rows from a SELECT statement.  

The phplib num_rows is a thin wrapper around the php
function for the specific database you are using, it doesn't
create a num_rows in php.  A php version could be written;
however it would suffer horrible memory issues and would not
perform well on large queries.

The warning in the documentation I belive is there to make
the users aware that this specific fucntion isn't generally
well implemented by the udnerlying ODBC drivers, and
therefore isn't always availible.

Isn't there also a warning for async db's (like oracle) to
emulate this by getting the count of the intended query? 
Would this also work for the ODBC drivers as well?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=403611&aid=478978&group_id=31885