/SQL/scripts/db/dbudt.asp
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) & " </TD>" & vbCrLf 39 myObjStr.strAppend "<TD>" & myArrUdt(6, i) & " </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" -->