/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. <TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 CLASS="content" SUMMARY="Database Information">
  16. <TR><TD CLASS="caption">
  17. <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>
  18. <TR><TD>
  19. <TABLE BORDER=0 CELLPADDING=2 CELLSPACING=2 ALIGN=CENTER CLASS="content" SUMMARY="User Defined Type List">
  20. <THEAD>
  21. <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>
  22. </THEAD>
  23. <TBODY>
  24. <%
  25. Set myObjStr = New mlt_string
  26. For i = 0 To myUdtCount
  27. myUdtName = "[" & rembracket(myArrUdt(1, i) ) & "].[" & rembracket(myArrUdt(0, i)) & "]"
  28. If i MOD 2 = 0 Then myStrClass = "odd" Else myStrClass = "even" End If
  29. myObjStr.strAppend "<TR CLASS=""" & myStrClass & """>" & vBCrLf
  30. 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""> "
  31. myObjStr.strAppend "<B>" & myArrUdt(0, i) & "</B>"
  32. myObjStr.strAppend "</TD>" & vbCrLf
  33. myObjStr.strAppend "<TD>" & myArrUdt(1, i) & "</TD>" & vbCrLf
  34. myObjStr.strAppend "<TD>" & myArrUdt(2, i) & "</TD>" & vbCrLf
  35. myObjStr.strAppend "<TD ALIGN=RIGHT>" & myArrUdt(3, i) & "</TD>" & vbCrLf
  36. myObjStr.strAppend "<TD ALIGN=RIGHT>" & myArrUdt(4, i) & "</TD>" & vbCrLf
  37. myObjStr.strAppend "<TD>" & myArrUdt(5, i) & "&nbsp;</TD>" & vbCrLf
  38. myObjStr.strAppend "<TD>" & myArrUdt(6, i) & "&nbsp;</TD>" & vbCrLf
  39. myObjStr.strAppend "</TR>" & vBCrLf
  40. Next
  41. Response.Write myObjStr.getStr()
  42. Set myObjStr = Nothing
  43. %>
  44. </TBODY>
  45. </TABLE>
  46. </TD></TR>
  47. </TABLE>
  48. </BODY>
  49. </HTML>
  50. <!-- #INCLUDE FILE="../inc/mla_sql_end.asp" -->