please stop the testing with the reported bug. It is "my" bug.
Today i've tested the whole day and i found out by logging the SQL-Statements that sometimes 2 request from the select-script are coming. The first without the needed parameter and the second with. And that's related by a bug in our select-scipt. Now i'm really shamed. :-( Sorry for my wrong bug report. With best regards Albert Steckenborn "Albert Steckenborn" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:apgfdd$2lh$1@;main.gmane.org... > > Two month ago i've opened a ADABAS-related bug report at "PHP.Net" with the > same Problem. > > It seems as if the ODBC-Driver of SAPDB and ADABAS is working in > the same way, so that the same problems occours. > > I think, that the ODBC_close($conn) don't works so that a PHP-Error occours > when the same client > is connecting from PHP to SAPDB a second time within 10 seconds after the > first connect. > > > But with Adabas there was a big Memory-leak. That was our reason to change > to SAPDB. > > With SAPDB and the newest Versions of PHP and APACHE > our Memory Problem is fixed. > > My question to the SAPDB Team is: > Is this bug PHP-related or SAPDB related????? > > Thanks for your answer > > 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
