Re: Re: php and db/c
| From: | Frank M. Kromann | Date: | Sat, 04 Jan 2003 06:20:00 +0000 |
| Subject: | Re: Re: php and db/c | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24543@lists.php.net to get a copy of this message | ||
According to the specs for ODBC (and SQL92) it is ok to return -1 for the
number of rows, as the correct number might not be available until the
last row has been fetched.
- Frank
> jay@advmed.com wrote:
> > Hello everyone,
> > We are running an old database system called db/c and attempting
to access
> > the information via php. We have managed to make an odbc connection to
the
> > databases, and can successfully retrieve the field names, and field
counts.
> > However, php insists the tables are empty, returning -1 (empty set)
for the
> > odbc_num_rows(). When we make a raw odbc connection to run a direct
sql query
> > on the data, it all shows up fine. There is some miscommunication
between odbc
> > and php that is eluding us. Any input or suggestions would be
welcomed.
> > Thank you,
> > Jay Merritt
> > jay@advmed.com
> Many odbc drivers do not return the correct value for odbc_num_rows.
> Have you tried odbc_result_all to see what comes back?
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>