#23146 [Bgs->Opn]: odbc_result column 1 empty after first use

From: Date: Wed, 23 Apr 2003 10:20:41 +0000
Subject: #23146 [Bgs->Opn]: odbc_result column 1 empty after first use
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-38202@lists.php.net to get a copy of this message
 ID:               23146
 User updated by:  wohlfarth dot m at web dot de
 Reported By:      wohlfarth dot m at web dot de
-Status:           Bogus
+Status:           Open
 Bug Type:         ODBC related
 Operating System: Win2k SP2
 PHP Version:      4.3.1
 New Comment:

Here still a few information to the problem:
- Database: Sybase Anywhere Version 7
- Webserver: Apache 2.0 with OpenSSL
- ODBC: Version 3.520

In the meantime I found still out that the problem arises, if the
column from a Subquery were 

produced.

Query sample:
select distinct a.column1, a.column2,

(select List(b.column1) from Table2 as b 
where b.Prim = a.Prim) as ListColumn

from Table1 as a
where a.Prim = 1


Previous Comments:
------------------------------------------------------------------------

[2003-04-23 03:59:53] sniper@php.net

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.


.

------------------------------------------------------------------------

[2003-04-10 04:04:45] wohlfarth dot m at web dot de

$idresult2 = odbc_exec($iddb, $sqlqry2);
odbc_fetch_row($idresult2);

// Column 1 contains a string
if ( odbc_result($idresult2, 1) <> "" ) {
   // Column 1 is now empty
   echo odbc_result($idresult2, 1);
};

------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=23146&edit=1



Thread (14 messages)

« previous php.bugs (#38202) next »