I've seen now, that the error comes only up when I'm starting the request again within 10seconds. Could it be that the ODBC_Close($conn) don't work with SAPDB.
with best regards Albert Steckenborn SteboSoft, Ludwigshafen "Albert Steckenborn" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:apdsf7$cg5$1@;main.gmane.org... > Hi all, > i'm getting the following unbelievable Error-Message in PHP with working > fine SQL-Statement. > The wanted results are printed out but also in the PHP.log the following > PHP-Error-Message. > > ------snip--------- > [26-Oct-2002 11:28:03] PHP Warning: SQL error: [SAP AG][LIBSQLOD SO][SAP > DB]Syntax error or access violation; > -3014 POS(260) Invalid end of SQL statement., SQL state 37000 in > SQLExecDirect in /www/kunden/reisenetz/web/show.phtml on line 153 > ------snip--------- > Thats the SQL-Statement: > > select > ABFLUGHAFEN_HIN,REISETERMIN,REISEDAUER,BELEGUNG,REISEART_LANGTEXT,HOTELNAME, > BESCHREIBUNG_LANGT,DARSTELLUNGSCODE,ZIELORT,ZIELGEBIET_LANGTEX,LAENDERNAME, > HOTELKATEGORIE,VERANSTALTER,REISETYP,PREIS,WAEHRUNG,HEX(SYSKEY) > from LAST > where REISETYP = 2 and ABFLUGHAFEN_HIN = 'FRA' and ZIEL_REGIO between 1 and > 5 and DAUER_GRUPPE = 4 and BELEGUNG = 2 and PREIS <= 99999 and > HOTELKATEGORIE between 1 and 6 and VERPFLEGUNG between 1 and 7 and > REISETERMIN between '2002-10-27' and '2002-11-01' and VERANSTALTER not > IN('OGER','ATT','ALL','BU') and ab_regio=1 > order by REISETERMIN,PREIS, > HOTELKATEGORIE,VERPFLEGUNG,REISEDAUER,LAENDERNAME,ZIELGEBIET_LANGTEX,VERANST > ALTER > > In SQL Studio the same Sql-Statement is working without any Error Messages > I don't believe that results are printed out when there should be a wrong > SQL statement. > > Used Versions: > SAPDB 7.3.00.25 > PHP 4.2.3 > Apache 1.3.27 > > Webserver is not the same as Database Machine. > > > Hope you can help me. > > With best regards > > Albert Steckenborn > SteboSoft, Ludwigshafen _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
