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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
