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. -----Mensaje original----- De: Bug Database [mailto:[EMAIL PROTECTED]] Enviado el: jueves, 21 de junio de 2001 10:51 Para: [EMAIL PROTECTED] Asunto: Bug #11595 Updated: Error in the migration PHP3 to PHP4 with OpenLink-ODBC drive ID: 11595 Updated by: ahill Reported By: [EMAIL PROTECTED] Status: Open Bug Type: ODBC related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: Nico, What error to you show? Best regards, Andrew Hill OpenLink Software Previous Comments: --------------------------------------------------------------------------- [2001-06-20 18:27:41] [EMAIL PROTECTED] When I migrated from PHP3 to PHP4 this script didn't work any more. I don't have connection problems and the error appears just in some cases. The following is an ad-hoc script that reproduce the odbc error. // PHP Version 4.0.4pl1 // OS: Solaris 2.7 // Driver: ODBC-Openlink multi-tier 3.2 // this connection works fine. $conn_id = odbc_connect("Driver=/psitio/openlink/odbcsdk/lib/oplodbc.so.1;Host=sql02.lo cal;SVT=SQLServer 7;UID=batalla_web;PWD=mundial86;DATABASE=elsitiodb2;FetchBufferSize=40000"," ",""); echo "my connection $conn_id<BR>"; $qry = "SELECT P.* FROM REAL_CAT_PADRE P WHERE IDIOMA = '" . $idioma . "' " . "AND P.ID_PADRE IN (SELECT H.ID_HIJO FROM REAL_CAT_HIJO H WHERE " . " H.ID_PADRE = '" . $cat . "') "; // this query works. $qry = "SELECT * FROM REAL_CAT_HIJO"; // this query doesn't work IN PHP4 but works fine in PHP3 with the same ODBC-OPENLINK drive(??). $qry = "SELECT idvalor,Valor,Tipo_rango FROM Fot_atributo_valor WHERE idcanal=41 AND idaplic=1 AND idatrib=2 ORDER BY idvalor"; $res_id = odbc_prepare($conn_id,$qry); // the error occur in this code line (IN PHP4). $result = odbc_execute($res_id); Thanks in advance. Nico. --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=11595&edit=2 -- 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]