ID: 46195
Updated by: [EMAIL PROTECTED]
Reported By: marcus dot kunze at syntela dot de
-Status: Open
+Status: Assigned
Bug Type: ODBC related
Operating System: Windows
PHP Version: 5.2.6
-Assigned To:
+Assigned To: iodbc
Previous Comments:
------------------------------------------------------------------------
[2008-09-29 12:09:01] marcus dot kunze at syntela dot de
Description:
------------
odbc_prepare use SQLNumResultCols to get the count and description of
den result column. The problem is a resultset the is depends on the
paremeter or a multiple resultset with differens column.
SQLNumResultCols return only the correct result after SQLExecute is
call! In odbc_execute is the same code, the code in odbc_prepare is
needless.
Testet Solution on Windows, SQL Server 2005
php_odbc.c[908]
result->numcols = 0;
/*
SQLNumResultCols(result->stmt, &(result->numcols));
if (result->numcols > 0) {
if (!odbc_bindcols(result TSRMLS_CC)) {
efree(result);
RETURN_FALSE;
}
} else {
result->values = NULL;
}
*/
zend_list_addref(conn->id);
Reproduce code:
---------------
$connstr = "Driver={SQL Server};SERVER=localhost;DATABASE=master";
$sql = "select 1 as col1 \n".
"select 2 as col2, 3 as col3 \n".
"select 4 as col4, 5 as col5, 6 as col6";
$conn = odbc_connect($connstr, $username, $password);
$result = odbc_prepare($conn, $sql );
odbc_execute( $result );
do {
odbc_result_all( $result );
} while ( odbc_next_result( $result ) );
Expected result:
----------------
col1
1
col2 col3
2 3
col4 col5 col6
4 5 6
Actual result:
--------------
col4 col5 col6
1 ÷xÈøx4[ú øx÷x4[ú
col2 col3
2 3
col4 col5 col6
4 5 6
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=46195&edit=1
