|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #46195 odbc_prepare use SQLNumResultCols
Submitted: 2008-09-29 12:09 UTC Modified: 2020-10-05 16:12 UTC
Avg. Score:4.0 ± 1.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:1 (100.0%)
From: marcus dot kunze at syntela dot de Assigned: cmb (profile)
Status: Closed Package: ODBC related
PHP Version: 5.2.6 OS: Windows
Private report: No CVE-ID: None
 [2008-09-29 12:09 UTC] marcus dot kunze at syntela dot de
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
   result->numcols = 0;
   SQLNumResultCols(result->stmt, &(result->numcols));
   if (result->numcols > 0) {
	if (!odbc_bindcols(result TSRMLS_CC)) {
   } else {
	result->values = NULL;

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:

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


Add a Patch

Pull Requests

Pull requests:

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2008-11-07 12:03 UTC]
Strictly speaking from an ODBC API point of view, you can call 
SQLNumResultCols directly after SQLPrepare, but not all 
drivers/databases evaluate the SQL statement at prepare time and therefor can only return this information after SQLExecute.

I am working on a patch that will resolve calling SQLNumResultCols and 
more importantly the odbc_bindcols call multiple times, without the 
possibility of breaking backward compatibility on existing apps.
 [2008-11-07 12:41 UTC] marcus dot kunze at syntela dot de
if the result depends on parameter from Execute, SQLNumResultCols can not return die correct result.


create procedure test ( @param int )
   if @param = 1  select 1 as col1
   else if @param = 2  select 2 as col2
   else if @param = 3  select 3 as col3
   else  select 'other' as other

odbc_prepare('exec test(?)');

bevor not execute with the paramter vor ?, SQLNumResultCols can not have the name vor the column.
 [2017-10-24 06:56 UTC]
-Status: Assigned +Status: Open -Assigned To: iodbc +Assigned To:
 [2020-10-05 16:12 UTC]
-Status: Open +Status: Closed -Assigned To: +Assigned To: cmb
 [2020-10-05 16:12 UTC]
This issue appears to have been resolved in the meantime.
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Sat Oct 31 07:01:24 2020 UTC