Index: _csp/httplog/queryVH.csp =================================================================== diff -u -r757 -r1254 --- _csp/httplog/queryVH.csp (.../queryVH.csp) (revision 757) +++ _csp/httplog/queryVH.csp (.../queryVH.csp) (revision 1254) @@ -60,11 +60,9 @@ Set sqlTBX=sqlTBX_$C(13,10)_" DECODE(Domein, '"_$$$DomVHEPN_"','vh', '"_$$$DomHEIN_"','hein', '"_$$$DomOPTIMA_"','optima', '"_$$$DomDUPONT_"','dupont', '"_$$$DomHELMY_"','destil', '"_$$$DomHFLE_"','hafele', '"_$$$DomSFS_"','sfs', Domein) Domein, ClientHost" Set sqlTBX=sqlTBX_$C(13,10)_" FROM DW_WWW.SysLogTBX WHERE LogTime %STARTSWITH '"_$ZD($H,3)_"' " */ - #If $$$NSpace="HADEV" - Set StartFromID=" (ID > 900000) AND" - #Else + + ;Set StartFromID=" (ID > 900000) AND" Set StartFromID="" - #EndIf Set sqlTBX="SELECT ID, Actie, WizardMode Mode, WSBonType TYPE, TO_CHAR(WSOrderID) OrdID, WSTotals, KlantNr KLNr, Verwerker VERW, LogTime, Taal, DomeinKort Domein, ClientHost" Set sqlTBX=sqlTBX_$C(13,10)_" FROM DW_WWW.SysLogTBX WHERE"_StartFromID_" LogTime %STARTSWITH '"_$ZD($H,3)_"' "