Login | Register
My pages Projects Community openCollabNet

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Catacomb] newlines in error_log



My SQL requests are about one screen long. …

When I look at them in the error_log, I can’t understand anything because I see something like this :

 

SELECT k.KEYIDENT serialno,CONCAT(CONCAT('/sdsd','/'),k.KEYCODE) URI,k.KEYCREATE creatio

ndate,k.KEYCODE displayname,'fr' getcontentlanguage,0 getcontentlength,'text/plain' getcontenttype,'NULL' getetag,k.KEYCREATE getlastmodified,1

 resourcetype,0 source,13 depth,1 istext, 0 isexternal, 0 isversioned, -1 checkin, -1 checkout From  ORA006_KEYWORD k WHERE ((k.KEYIDENT>=40 AN

D k.KEYIDENT<44) OR k.KEYIDENT=65 OR k.KEYIDENT=72) AND k.KEYCODE!= 'COULEUR' AND k.KEYCODE!= 'DATE_CREA' AND k.KEYCODE!= 'TAILLE' AND k.KEYCOD

E!= 'PRIX' AND k.KEYCODE!= 'TEMP' AND k.KEYCODE!= 'AGE' UNION select DISTINCT l.LOTIDENT serialno,CONCAT(CONCAT('/arcsys','/'),l.LOTCODE) URI,l

.LOTCREATE creationdate,l.LOTLIBELLE displayname,'fr' getcontentlanguage,0 getcontentlength,'text/plain' getcontenttype,'NULL' getetag,l.LOTCRE

ATE getlastmodified,1 resourcetype,0 source,13 depth,1 istext, 0 isexternal, 0 isversioned, -1 checkin, -1 checkout FROM ORA002_LOT l,ORA007_ME

TAD m WHERE l.LOTIDENT=m.LOTIDENT AND ( EXISTS ( SELECT m.METIDENT FROM ORA007_METAD m, ORA008_VALUES v, ORA027_KEYVAL kv, ORA006_KEYWORD k WHE

RE m.LOTIDENT=l.LOTIDENT AND m.KEYIDENT=k.KEYIDENT AND m.VALIDENT=v.VALIDENT AND v.VALIDENT=kv.VALIDENT AND kv.KEYIDENT=k.KEYIDENT  AND k.KEYCO

DE='COULEUR' AND v.VALVALUE='bleu')AND ( EXISTS ( SELECT m.METIDENT FROM ORA007_METAD m, ORA008_VALUES v, ORA027_KEYVAL kv, ORA006_KEYWORD k WH

ERE m.LOTIDENT=l.LOTIDENT AND m.KEYIDENT=k.KEYIDENT AND m.VALIDENT=v.VALIDENT AND v.VALIDENT=kv.VALIDENT AND kv.KEYIDENT=k.KEYIDENT  AND k.KEYC

ODE='DATE_CREA' AND v.VALVALUE='2004-05-16 00:00:00')AND ( EXISTS ( SELECT m.METIDENT FROM ORA007_METAD m, ORA008_VALUES v, ORA027_KEYVAL kv, A

RO006_KEYWORD k WHERE m.LOTIDENT=l.LOTIDENT AND m.KEYIDENT=k.KEYIDENT AND m.VALIDENT=v.VALIDENT AND v.VALIDENT=kv.VALIDENT AND kv.KEYIDENT=k.KE

YIDENT  AND k.KEYCODE='TAILLE' AND v.VALVALUE='grand')AND ( EXISTS ( SELECT m.METIDENT FROM ORA007_METAD m, ORA008_VALUES v, ORA027_KEYVAL kv,

ORA006_KEYWORD k WHERE m.LOTIDENT=l.LOTIDENT AND m.KEYIDENT=k.KEYIDENT AND m.VALIDENT=v.VALIDENT AND v.VALIDENT=kv.VALIDENT AND kv.KEYIDENT=k.K

EYIDENT  AND k.KEYCODE='PRIX' AND v.VALVALUE='150')AND ( EXISTS ( SELECT m.METIDENT FROM ORA007_METAD m, ORA008_VALUES v, ORA027_KEYVAL kv, ORA

006_KEYWORD k WHERE m.LOTIDENT=l.LOTIDENT AND m.KEYIDENT=k.KEYIDENT AND m.VALIDENT=v.VALIDENT AND v.VALIDENT=kv.VALIDENT AND kv.KEYIDENT=k.KEYI

DENT  AND k.KEYCODE='TEMP' AND v.VALVALUE='chaud')AND ( EXISTS ( SELECT m.METIDENT FROM ORA007_METAD m, ORA008_VALUES v, ORA027_KEYVAL kv, ORA0

( … )

 

So my question is : is there a way to make newlines appear in the error log ? I tried to put \n

\\n , \r \\r \r\n \n\r in the DEBUG function but none of these work …