PageRenderTime 8ms CodeModel.GetById 1ms app.highlight 2ms RepoModel.GetById 2ms app.codeStats 0ms

/SQL/scripts/db/dbudt.asp

http://github.com/khaneh/Orders
ASP | 52 lines | 50 code | 2 blank | 0 comment | 0 complexity | c2b2cc5bd50b77e8585535e15357a5b8 MD5 | raw file
 1<!-- #INCLUDE FILE="../inc/mla_sql_include.asp" -->
 2<%
 3	Dim myDbName, myNodeId, myArrUdt, myUdtCount, i, myObjStr, myStrClass, myStrTree, myUdtName
 4	myNodeId = Request.QueryString("nid")
 5	myDbName = Request.QueryString("db")
 6	openConnection
 7	myStrTree = getTreeStr(Mid(myNodeId, 2) & "_8", Array(myDbName))
 8	myArrUdt = getDbUdt(myDbName)
 9	closeConnection
10	If isArray(myArrUdt) Then myUdtCount = UBound(myArrUdt, 2) Else myUdtCount = -1 End If
11%>
12<!-- #INCLUDE FILE="../inc/metaheader.asp" -->
13<BODY>
14	<P	 CLASS="treeinfo"><% = myStrTree %></P>
15
16	<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 CLASS="content" SUMMARY="Database Information">
17		<TR><TD CLASS="caption">
18		<IMG SRC="../../themes/<% = mla_cfg_theme %>/images/mylittletree/udt.gif" WIDTH="16" HEIGHT="16" BORDER=0 ALIGN="MIDDLE" ALT="User Defined Types"> <% = myTObj.getTerm(14) %></TD></TR>
19		<TR><TD>
20			<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=2 ALIGN=CENTER CLASS="content" SUMMARY="User Defined Type List">
21				<THEAD>
22					<TR><TD CLASS="collabel"><% = myTObj.getTerm(200) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(121) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(201) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(202) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(203) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(190) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(180) %></TD></TR>
23				</THEAD>
24				<TBODY>
25					<%
26						Set myObjStr = New mlt_string
27						For i = 0 To myUdtCount
28							myUdtName = "[" & rembracket(myArrUdt(1, i) ) & "].[" & rembracket(myArrUdt(0, i)) & "]"
29							If i MOD 2 = 0 Then myStrClass = "odd" Else myStrClass = "even" End If
30							myObjStr.strAppend "<TR CLASS=""" & myStrClass & """>" & vBCrLf
31							myObjStr.strAppend "<TD><IMG SRC=""../../themes/" & mla_cfg_theme & "/images/mylittletree/udt.gif"" WIDTH=""16"" HEIGHT=""16"" BORDER=0 ALT=""" & myArrUdt(0, i) & """ ALIGN=""MIDDLE""> "
32							myObjStr.strAppend "<B>" & myArrUdt(0, i) & "</B>"
33							myObjStr.strAppend "</TD>" & vbCrLf
34							myObjStr.strAppend "<TD>" & myArrUdt(1, i) & "</TD>" & vbCrLf
35							myObjStr.strAppend "<TD>" & myArrUdt(2, i) & "</TD>" & vbCrLf
36							myObjStr.strAppend "<TD ALIGN=RIGHT>" & myArrUdt(3, i) & "</TD>" & vbCrLf
37							myObjStr.strAppend "<TD ALIGN=RIGHT>" & myArrUdt(4, i) & "</TD>" & vbCrLf
38							myObjStr.strAppend "<TD>" & myArrUdt(5, i) & "&nbsp;</TD>" & vbCrLf
39							myObjStr.strAppend "<TD>" & myArrUdt(6, i) & "&nbsp;</TD>" & vbCrLf
40							myObjStr.strAppend "</TR>" & vBCrLf
41						Next
42						Response.Write myObjStr.getStr()
43						Set myObjStr = Nothing
44					%>
45				</TBODY>
46			</TABLE>
47		</TD></TR>
48	</TABLE>
49
50</BODY>
51</HTML>
52<!-- #INCLUDE FILE="../inc/mla_sql_end.asp" -->