PHP4 4.04pl1 ODBC/Openlink/Progress8.3 COUNT Problem
| From: | Grant Walters | Date: | Thu, 19 Apr 2001 23:30:19 +0000 |
| Subject: | PHP4 4.04pl1 ODBC/Openlink/Progress8.3 COUNT Problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-49446@lists.php.net to get a copy of this message | ||
Hi,
Using the above combination I issue the statement
SELECT COUNT(*) FROM mytable
I have tried using either odbc_prepare or odbc_do with each of the cursor types
SQL_CUR_USE_ODBC
SQL_CUR_IF_NEEDED
SQL_CUR_USE_DRIVER
SQL_CUR_DEFAULT
Instead of geting a resultset set with 1 row containing the count I am getting a resultset as
follows:
executing 'SELECT COUNT(*) FROM mytable'
NUM_ROWS:9
COUNT
1
1
1
1
1
1
1
1
1
I have issued the same SQL statemnt with the Progress tools and with the openlink odbctest program
and they both return 1 row with
the result
COUNT
9
Any help appreciated.
Regards
Grant Walters
Brainbench 'Most Valuable Professional' for Unix Admin
Walters & Associates, P O Box 13-043 Johnsonville, Wellington, NEW ZEALAND
Telephone: +64 4 4765175, CellPhone 025488265, ICQ# 23511989