#46195 [Opn->Asn]: odbc_prepare use SQLNumResultCols

From: Date: Wed, 01 Oct 2008 23:56:00 +0000
Subject: #46195 [Opn->Asn]: odbc_prepare use SQLNumResultCols
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-129403@lists.php.net to get a copy of this message 
 ID:               46195
 Updated by:       felipe@php.net
 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

Thread (6 messages)

« previous php.bugs (#129403) next »