Index: _csp/admin1/vhLogging.csp =================================================================== diff -u -r757 -r916 --- _csp/admin1/vhLogging.csp (.../vhLogging.csp) (revision 757) +++ _csp/admin1/vhLogging.csp (.../vhLogging.csp) (revision 916) @@ -1,4 +1,4 @@ - + @@ -28,6 +28,12 @@ .clsQActions { background-color:#DDDDFF; border:solid 1px darkblue; padding:5px;} .clsQStatusON { color:#008010; font-weight:bold; } .clsQStatusOFF { color:#FF0000; font-weight:bold; } + + .clsDetailDataExp { position:relative; margin-top:2px; width:900; overflow-x:visible; overflow-y:hidden; height:auto; background-color:#DDDDFF; border:solid 1px darkblue; } + .clsDetailDataCol { position:relative; margin-top:2px; width:900; overflow-x:hidden; overflow-y:hidden; height:18px; background-color:transparent; border:none; padding:1px; } + .clsDetailDataHdr { color:darkblue; text-decoration:underline; cursor:pointer; } + .clsDetailInfo { font-size:7pt; font-weight:normal; padding-left:5px; } + #($G(CspPageTitle, ..%ClassName(0))_$G(OnServer))# @@ -56,6 +62,32 @@ --> + + + @@ -65,8 +97,6 @@ 
#(sqlAll)#
- -
@@ -78,12 +108,12 @@


- +
  -   +  

@@ -118,17 +148,71 @@ - + - #($S(blnAddLink:">", 1:" "))# + #($S(blnAddLink:">", 1:" ")_row)# + - #($S($L(tmpVal):tmpVal,1:" "))# + + +
#($S($L(tmpVal):tmpVal,1:" "))#
+ + + +
+

Summary: #($S($L(tmpDataSummary):tmpDataSummary, 1:" "))#

+ 
#($S($L(tmpVal):tmpVal,1:" "))#
 +
+ + + + + +
+ 
+#($E(tmpVal,1,32000))#
+
+
+ + @@ -159,9 +243,11 @@ /*** SQL STATEMENTS ***/ /*** ============== ***/ ; SQL-statement for FOP Queue - Set sqlLOG="SELECT Top 100 Datum , Tijd , Groep, Niveau , Actie , JobID , Detail" + Set sqlLOG="SELECT Top 100 Datum, Tijd, Groep, Niveau, Actie, JobID, LessDetail, DetailTrunc As Detail, ID , MainIndex , Namespace , RemoteIP , Server , ProgLabel , SubID " + Set sqlLOG="SELECT Top 100 Datum, Tijd, Groep, Niveau, Actie, JobID, LessDetail, DetailTrunc As Detail" + Set sqlLOG=sqlLOG_$C(13,10)_" FROM vhLib.Logging WHERE Niveau = 'E' OR Niveau = 'W' " - Set sqlLOG=sqlLOG_$C(13,10)_" ORDER BY Datum DESC, Tijd DESC" + Set sqlLOG=sqlLOG_$C(13,10)_" ORDER BY Datum DESC, SubID DESC" ; SQLs to be displayed Set sqlDFL=$S(1:sqlLOG) @@ -174,26 +260,25 @@ ; Check if SQL-statement does not alter the tables data !!! Set lbAvoidSQL=$LB("CREATE TABLE","ALTER TABLE","DROP TABLE","CREATE QUERY","DROP QUERY","INSERT","UPDATE","DELETE") - Set CspPageTitle="VH LOGGING" Quit 1