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
