PageRenderTime 4ms CodeModel.GetById 1ms app.highlight 0ms RepoModel.GetById 1ms app.codeStats 1ms

/SQL/scripts/srv/srvcon.asp

http://github.com/khaneh/Orders
ASP | 56 lines | 54 code | 2 blank | 0 comment | 0 complexity | 52f763ed46818c9ed0fc96bdccfef680 MD5 | raw file
 1<!-- #INCLUDE FILE="../inc/mla_sql_include.asp" -->
 2<%
 3	Dim myArrCon, myConCount, i, myObjStr, myStrClass, myStrImg, myStrTree
 4	openConnection
 5	myStrTree = getTreeStr("2_3_1", Array())
 6	myArrCon = getSrvCon()
 7	closeConnection
 8	If isArray(myArrCon) Then myConCount = UBound(myArrCon, 2) Else myConCount = -1 End If
 9%>
10<!-- #INCLUDE FILE="../inc/metaheader.asp" -->
11<BODY>
12	<P CLASS="treeinfo"><% = myStrTree %></P>
13
14	<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 CLASS="content" SUMMARY="Database Information">
15		<TR><TD CLASS="caption">
16		<IMG SRC="../../themes/<% = mla_cfg_theme %>/images/mylittletree/connection.gif" WIDTH="16" HEIGHT="16" BORDER=0 ALIGN="MIDDLE" ALT="Connections"> <% = myTObj.getTerm(230) %></TD></TR>
17		<TR><TD>
18			<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=2 ALIGN=CENTER CLASS="content" SUMMARY="Connection List">
19				<THEAD>
20					<TR><TD CLASS="collabel"><% = myTObj.getTerm(240) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(241) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(242) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(243) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(122) %></TD></TR>
21				</THEAD>
22				<TBODY>
23					<%
24						Set myObjStr = New mlt_string
25						For i = 0 To myConCount
26							If i MOD 2 = 0 Then myStrClass = "odd" Else myStrClass = "even" End If
27							Select Case myArrCon(1, i) 
28								Case 1: myStrImg = "connection_ntgroup.gif"
29								Case 2 : myStrImg = "connection_ntuser.gif"
30								Case Else : myStrImg = "connection.gif"
31							End Select
32							myObjStr.strAppend "<TR CLASS=""" & myStrClass & """>" & vbCrLf
33							myObjStr.strAppend "<TD NOWRAP><IMG SRC=""../../themes/" & mla_cfg_theme & "/images/mylittletree/" & myStrImg & """ WIDTH=""16"" HEIGHT=""16"" BORDER=0 ALT=""" & myArrCon(0, i) & """ ALIGN=""MIDDLE""> "
34							myObjStr.strAppend "<B>" & myArrCon(0, i) & "</B>"
35							myObjStr.strAppend "</TD>" & vbCrLf
36							Select Case myArrCon(1, i) 
37								Case 1 : myObjStr.strAppend "<TD>" & myTObj.getTerm(244) & "</TD>" & vbCrLf
38								Case 2 : myObjStr.strAppend "<TD>" & myTObj.getTerm(245) & "</TD>" & vbCrLf
39								Case Else : myObjStr.strAppend "<TD>" & myTObj.getTerm(223) & "</TD>" & vbCrLf
40							End Select
41							myObjStr.strAppend "<TD>" & myArrCon(2, i) & "</TD>" & vbCrLf
42							myObjStr.strAppend "<TD>" & myArrCon(3, i) & "</TD>" & vbCrLf
43							myObjStr.strAppend "<TD>" & myArrCon(4, i) & "</TD>" & vbCrLf
44							myObjStr.strAppend "</TR>" & vbCrLf
45						Next
46						Response.Write myObjStr.getStr()
47						Set myObjStr = Nothing
48					%>
49				</TBODY>
50			</TABLE>
51		</TD></TR>
52	</TABLE>
53
54</BODY>
55</HTML>
56<!-- #INCLUDE FILE="../inc/mla_sql_end.asp" -->