ID: 23146
Updated by: kalowsky@php.net
Reported By: wohlfarth dot m at web dot de
-Status: Open
+Status: Feedback
Bug Type: ODBC related
Operating System: Win2k SP2
PHP Version: 4.3.1
New Comment:
Don't mind sniper, he's a little over-zealous with the bogus-ification.
You're correct though that SELECT DISTINCT does create problems with
the ODBC system at the moment. I haven't yet been able to figure out
why.
Any chance you can create a log of the SQL transactions (SQL Log option
on your ODBC Administrator) and post it here?
Previous Comments:
------------------------------------------------------------------------
[2003-04-23 05:20:41] wohlfarth dot m at web dot de
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
------------------------------------------------------------------------
[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