#26348 [NEW]: odbc_statistics()
| From: | frosty dot z at freesbee dot fr | Date: | Fri, 21 Nov 2003 12:19:46 +0000 |
| Subject: | #26348 [NEW]: odbc_statistics() | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-50803@lists.php.net to get a copy of this message | ||
From: frosty dot z at freesbee dot fr
Operating system: Win 2000
PHP version: 4.3.4
PHP Bug Type: ODBC related
Bug description: odbc_statistics()
Description:
------------
Good morning,
I've tried to use the function odbc_statistics() to get information from
tables of a Filemaker Pro database (using ODBC driver).
With any value I've tried, odbc_statistics() returns always FALSE (+ SQL
Error).
Thank you very much for any help or explanation ; I suppose this to be a
bug, but it might be a problem from the Filemaker ODBC driver as well.
... And sorry for the english mistakes (I'm french)
==========
Similar bugs : bug #25757, bug #18941
Reproduce code:
---------------
$id_odbc = odbc_connect(FM_HOST, FM_LOGIN, FM_PASSWORD);
$res = odbc_statistics($id_odbc, NULL, NULL, "product_family", 0, 0);
// I've tried "" and "%" instead of NULL for the 2nd and 3rd arguments
// I've tried many numbers for the last two (too few doc, I don't know
what they do)
$row = odbc_fetch_array($res);
//print $row['CARDINALITY'];
//etc.
Expected result:
----------------
I expected to be able to get some statistics of a table.
Actual result:
--------------
Here is the actual result :
Warning: odbc_statistics(): SQL error: , SQL state 00000 in
SQLStatistics in c:\maxime\prmt\appli\add_product.php on line 47
Warning: odbc_fetch_array(): supplied argument is not a valid ODBC
result resource in c:\maxime\prmt\appli\add_product.php on line 51
----------------
Curiously, SQL state 00000 means "success", and a SQL error is generated.
Since similar problems have been reported for other functions such as
odbc_columns, I guess this could be a PHP bug...
--
Edit bug report at http://bugs.php.net/?id=26348&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=26348&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=26348&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=26348&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=26348&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=26348&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=26348&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=26348&r=support
Expected behavior: http://bugs.php.net/fix.php?id=26348&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=26348&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=26348&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=26348&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=26348&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=26348&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=26348&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=26348&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=26348&r=float