ID: 11595 Updated by: ahill Reported By: [EMAIL PROTECTED] Old Status: Assigned Status: Closed Bug Type: ODBC related Operating System: Solaris 2.7 PHP Version: 4.0.4pl1 Assigned To: ahill New Comment:
unable to duplicate, no feedback Previous Comments: ------------------------------------------------------------------------ [2001-07-30 12:08:34] [EMAIL PROTECTED] Hi, Please try with 4.0.6 or submit an ODBC trace; I am unable to reproduce. Best regards, Andrew ------------------------------------------------------------------------ [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... ------------------------------------------------------------------------ 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]