PHP4 4.04pl1 ODBC/Openlink/Progress8.3 COUNT Problem

From: 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

« previous php.general (#49446) next »