|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2008-09-29 12:09 UTC] 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
PatchesPull Requests
Pull requests:
HistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Nov 06 22:00:01 2025 UTC |
Hallo, if the result depends on parameter from Execute, SQLNumResultCols can not return die correct result. Sample: create procedure test ( @param int ) as 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.