/SQL/scripts/db/viewstruct.asp

http://github.com/khaneh/Orders · ASP · 64 lines · 60 code · 4 blank · 0 comment · 0 complexity · ecbf84dee28ec77f4d51b79ef51f3217 MD5 · raw file

  1. <!-- #INCLUDE FILE="../inc/mla_sql_include.asp" -->
  2. <%
  3. Dim myNodeId, myDbName, myViewName, myArrCol, myColCount, i, myObjStr, myStrClass, myViewTxt, myStrTree
  4. myNodeId = Request.QueryString("nid")
  5. myDbName = Request.QueryString("db")
  6. myViewName = Request.QueryString("view")
  7. openConnection
  8. myStrTree = getTreeStr(Mid(myNodeId, 2) & "_2_2", Array(myDbName, myViewName))
  9. myArrCol = getViewCol(myDbName, myViewName)
  10. myViewTxt = txt2html(getObjTxt(myDbName, myViewName))
  11. closeConnection
  12. If isArray(myArrCol) Then myColCount = UBound(myArrCol, 2) Else myColCount = -1 End If
  13. %>
  14. <!-- #INCLUDE FILE="../inc/metaheader.asp" -->
  15. <BODY>
  16. <P CLASS="treeinfo"><% = myStrTree %></P>
  17. <TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 CLASS="content" SUMMARY="Database Information">
  18. <TR><TD CLASS="caption"><% = myTObj.getTerm(331) %></TD></TR>
  19. <TR><TD>
  20. <TABLE BORDER=0 CELLPADDING=2 CELLSPACING=2 ALIGN=CENTER CLASS="content" WIDTH="100%" SUMMARY="View Stucture">
  21. <THEAD>
  22. <TR><TD CLASS="collabel"><% = myTObj.getTerm(300) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(301) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(302) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(303) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(304) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(305) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(307) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(308) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(309) %></TD><TD CLASS="collabel"><% = myTObj.getTerm(310) %></TD></TR>
  23. </THEAD>
  24. <TBODY>
  25. <%
  26. Set myObjStr = New mlt_string
  27. For i = 0 To myColCount
  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 NOWRAP><B>" & myArrCol(0, i) & "</B></TD>" & vbCrLf
  31. myObjStr.strAppend "<TD NOWRAP>" & myArrCol(1, i) & "</TD>" & vbCrLf
  32. myObjStr.strAppend "<TD NOWRAP ALIGN=RIGHT>" & myArrCol(2, i) & "</TD>" & vbCrLf
  33. myObjStr.strAppend "<TD NOWRAP ALIGN=RIGHT>&nbsp;" & myArrCol(3, i) & "</TD>" & vbCrLf
  34. myObjStr.strAppend "<TD NOWRAP ALIGN=RIGHT>&nbsp;" & myArrCol(4, i) & "</TD>" & vbCrLf
  35. myObjStr.strAppend "<TD NOWRAP ALIGN=RIGHT>&nbsp;" & myArrCol(5, i) & "</TD>" & vbCrLf
  36. myObjStr.strAppend "<TD NOWRAP ALIGN=RIGHT>&nbsp;" & myArrCol(6, i) & "</TD>" & vbCrLf
  37. myObjStr.strAppend "<TD NOWRAP ALIGN=RIGHT>&nbsp;" & myArrCol(7, i) & "</TD>" & vbCrLf
  38. myObjStr.strAppend "<TD NOWRAP ALIGN=RIGHT>&nbsp;" & myArrCol(8, i) & "</TD>" & vbCrLf
  39. myObjStr.strAppend "<TD NOWRAP ALIGN=RIGHT>&nbsp;" & myArrCol(9, 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. &nbsp;<BR>
  48. <TABLE BORDER=0 CELLPADDING=2 CELLSPACING=2 ALIGN=CENTER CLASS="content" WIDTH="100%" SUMMARY="View Definition">
  49. <THEAD>
  50. <TR><TD CLASS="collabel"><% = myTObj.getTerm(161) %></TD></TR>
  51. </THEAD>
  52. <TBODY>
  53. <TR><TD><% = myViewTxt %></TD></TR>
  54. </TBODY>
  55. </TABLE>
  56. </TD></TR>
  57. </TABLE>
  58. </BODY>
  59. </HTML>
  60. <!-- #INCLUDE FILE="../inc/mla_sql_end.asp" -->