ID: 19045
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Feedback
+Status: Open
Bug Type: ODBC related
Operating System: IIS4 on NT4
PHP Version: 4.2.2
New Comment:
I didn't find any tab with 'logging on' checkbox in ODBC Administrator
program ; so, I changed the value of the 'Driver Logging' parameter to
17 in the oraodbc.ini file.
I hope it can help you...
Merci.
// logging results when the request works fine (with two joined
tables)
Oracle ODBC 32 Bit Driver Version 08.00.6000
Oracle ODBC 32 Bit Driver File Version 08.00.6000
....0X0013BA50: php 0X00000000
....0X0013F078: php 0X00000000
....0X0013F8D0: php 0X00000000
....0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES,
GROUPE_MACHINE where poste=machine
....0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES,
GROUPE_MACHINE where poste=machine
....0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES,
GROUPE_MACHINE where poste=machine
....0X0013FC70: Rows Fetched = 0X0000006E
// logging results when the request doesn't work fine (with one table)
Oracle ODBC 32 Bit Driver Version 08.00.6000
Oracle ODBC 32 Bit Driver File Version 08.00.6000
....0X0013BA50: php 0X00000000
....0X0013F078: php 0X00000000
....0X0013F8D0: php 0X00000000
....0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES
....0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES
....0X0013FC70: SELECT ROWID from TEMPSCUMULES
....0X0013FC70: SELECT ROWID,distinct SOCIETE, POSTE from TEMPSCUMULES
WHERE ROWID=''
....0X0013FC70: select distinct SOCIETE, POSTE from TEMPSCUMULES
Previous Comments:
------------------------------------------------------------------------
[2002-10-03 07:48:10] [EMAIL PROTECTED]
Open your ODBC Administrator and there should be tab that has a little
check box that says "Turn Logging On" I believe it's on the same tab as
the Pooling information.
------------------------------------------------------------------------
[2002-10-03 01:40:16] [EMAIL PROTECTED]
how I can turn the logging on ?
------------------------------------------------------------------------
[2002-10-02 12:28:21] [EMAIL PROTECTED]
Any chance you can re-do this with logging turned on? I did some
research into this, and believe I've figured it out.... although I'd
like to see if your actions fall into the same series of steps as mine.
------------------------------------------------------------------------
[2002-08-31 00:17:41] [EMAIL PROTECTED]
Interestingly enough some digging into this results in the following
data:
The ODBC standard exec only supports the following options for a SELECT
statement: FROM, WHERE, GROUP BY, HAVING, UNION, and ORDER BY.
So technically doing a SELECT DISTINCT shouldn't ever work. Although
your example seems to disprove this theory. I'm going to have to do
more looking into this as I get time... as I don't think this should be
an issue. It should be a SQL Driver issue, not an ODBC Driver issue.
------------------------------------------------------------------------
[2002-08-30 03:10:23] [EMAIL PROTECTED]
it doesn't work with :
$requete="select distinct POSTE from TEMPSCUMULES";
and it works with :
$requete="select POSTE from TEMPSCUMULES";
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/19045
--
Edit this bug report at http://bugs.php.net/?id=19045&edit=1
