ID: 11595
Updated by: ahill
Reported By: [EMAIL PROTECTED]
Status: Assigned
Bug Type: ODBC related
Operating System: Solaris 2.7
PHP Version: 4.0.4pl1
Assigned To: ahill
New Comment:
Hi,
Please try with 4.0.6 or submit an ODBC trace; I am unable to reproduce.
Best regards,
Andrew
Previous Comments:
------------------------------------------------------------------------
[2001-07-09 16:08:07] [EMAIL PROTECTED]
Nico,
Can you please generate a trace? I expect we will see a problem in the SQLPrepare
where it's dropping your subquery.
To enable tracing, add or uncomment the following line in the $ODBCINI file:
DebugFile=/tmp/opl_debug.out
and then please paste the resultant trace in.
Best regards,
Andrew Hill
OpenLink Software
------------------------------------------------------------------------
[2001-06-26 17:59:09] [EMAIL PROTECTED]
assigning to ahill as he knows openlink best :)
------------------------------------------------------------------------
[2001-06-21 11:13:00] [EMAIL PROTECTED]
Sorry,
message error:
Warning: SQL error: [OpenLink][ODBC][Driver]General error, SQL state S1000 in
SQLPrepare in /psitio/multihomed/www.elsitio.com/pub/cgi-bin/gl/av/player/test.php3 on
line 19
The most strange is that I reduce the query string "SELECT P.* FROM REAL_CAT_PADRE P
WHERE IDIOMA = 'C' AND P.ID_PADRE IN ( SELECT ID_HIJO FROM REAL_CAT_HIJO )" to "SELECT
P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = 'C'" it works fine IN PHP4...
I don't know is very strange.
Nico.
------------------------------------------------------------------------
[2001-06-21 11:10:52] [EMAIL PROTECTED]
marking as feedback until user responds...
------------------------------------------------------------------------
[2001-06-21 09:50:44] [EMAIL PROTECTED]
Nico,
What error to you show?
Best regards,
Andrew Hill
OpenLink Software
------------------------------------------------------------------------
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/?id=11595
Edit this bug report at http://bugs.php.net/?id=11595&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
