/SQL/scripts/db/trstruct.asp

http://github.com/khaneh/Orders · ASP · 34 lines · 31 code · 2 blank · 1 comment · 0 complexity · ffade8ee0e3eee4b808644bead88553f MD5 · raw file 

    

  1. <!-- #INCLUDE FILE="../inc/mla_sql_include.asp" -->

    2. 

  2. <%

    3. 

  3. 	Dim myNodeId, myDbName, myTblName, myTrName, myTrTxt, myStrTree

    4. 

  4. 	myNodeId = Request.QueryString("nid")

    5. 

  5. 	myDbName = Request.QueryString("db")

    6. 

  6. 	myTblName = Request.QueryString("tbl")

    7. 

  7. 	myTrName = Request.QueryString("tr")

    8. 

  8. 	openConnection

    9. 

  9. 	'myStrTree = getTreeStr(Array(myTObj.getTerm(5), myDbName, myTObj.getTerm(7), myTblName, myTObj.getTerm(328), myTrName))

    10. 

  10. 	myStrTree = getTreeStr(Mid(myNodeId, 2) & "_1_2_1", Array(myDbName, myTblName, myTrName))

    11. 

  11. 	myTrTxt = txt2html(getObjTxt(myDbName, myTrName))

    12. 

  12. 	closeConnection

    13. 

  13. %>

    14. 

  14. <!-- #INCLUDE FILE="../inc/metaheader.asp" -->

    15. 

  15. <BODY>

    16. 

  16. 	<P CLASS="treeinfo"><% = myStrTree %></P>

    17. 

  17. 

    18. 

  18. 	<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 CLASS="content" SUMMARY="Database Information">

    19. 

  19. 		<TR><TD CLASS="caption"><% = myTObj.getTerm(329) & " " & myTrName %></TD></TR>

    20. 

  20. 		<TR><TD>

    21. 

  21. 			<TABLE BORDER=0 CELLPADDING=2 CELLSPACING=2 ALIGN=CENTER CLASS="content" WIDTH="100%" SUMMARY="Triigger Definition">

    22. 

  22. 				<THEAD>

    23. 

  23. 					<TR><TD CLASS="collabel"><% = myTObj.getTerm(330) %></TD></TR>

    24. 

  24. 				</THEAD>

    25. 

  25. 				<TBODY>

    26. 

  26. 					<TR><TD><% = myTrTxt %></TD></TR>

    27. 

  27. 				</TBODY>

    28. 

  28. 			</TABLE>

    29. 

  29. 			

    30. 

  30. 		</TD></TR>

    31. 

  31. 	</TABLE>

    32. 

  32. </BODY>

    33. 

  33. </HTML>

    34. 

  34. <!-- #INCLUDE FILE="../inc/mla_sql_end.asp" -->
    35.