Subversion Repositories DevTools

Rev

Rev 13 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13 Rev 15
Line 55... Line 55...
55 
	OraDatabase.Parameters.Add "BOM_VERSION", 		Request("version"),		ORAPARM_INPUT, ORATYPE_NUMBER
 55 
	OraDatabase.Parameters.Add "BOM_VERSION", 		Request("version"),		ORAPARM_INPUT, ORATYPE_NUMBER
56 
	OraDatabase.Parameters.Add "BOM_LIFECYCLE", 	Request("lifecycle"),		ORAPARM_INPUT, ORATYPE_NUMBER
56 
	OraDatabase.Parameters.Add "BOM_LIFECYCLE", 	Request("lifecycle"),		ORAPARM_INPUT, ORATYPE_NUMBER
57 
	OraDatabase.Parameters.Add "OS_NAME", 			Request("os"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
57 
	OraDatabase.Parameters.Add "OS_NAME", 			Request("os"),		ORAPARM_INPUT, ORATYPE_VARCHAR2
58 
 
 58 
 
59 
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("patch_OsId.sql"), ORADYN_DEFAULT )
 59 
	Set rsQry = OraDatabase.DbCreateDynaset( GetQuery ("patch_OsId.sql"), ORADYN_DEFAULT )
- 
 
 60
- 
 
 61 
If rsQry.Recordcount > 0 Then
60 
%>
62 
%>
61 
<table width="20%"  border="0" cellspacing="3" cellpadding="0">
 63 
<table width="20%"  border="0" cellspacing="3" cellpadding="0">
62 
  <tr>
 64 
  <tr>
63 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Product</div>      <div align="center"></div></td>
 65 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Product</div>      <div align="center"></div></td>
64 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Package</div>      <div align="center"></div></td>
 66 
    <td colspan="2" valign="top" nowrap class="body_row style1 style2"><div align="center">Package</div>      <div align="center"></div></td>
Line 67... Line 69...
67 
    <td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
 69 
    <td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
68 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
 70 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
69 
	<td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
 71 
	<td width="50%" valign="top" nowrap class="style1 body_row"><div align="center">Name</div></td>
70 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
72 
    <td width="30%" valign="top" nowrap class="style1 body_row"><div align="center">Version</div></td>
71 
 </tr>
73 
 </tr>
72 
 
 - 
 
73 
 
 - 
 
74 
<%
 74 
<%
- 
 
 75 
Else
- 
 
 76 
Response.Write("No Patches Found For "&Request("node")&".")
- 
 
 77 
End If
75 
		While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 78 
		While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
76 
	OraDatabase.Parameters.Add "PV_ID", 	rsQry("pv_id"),		ORAPARM_INPUT, ORATYPE_NUMBER
79 
	OraDatabase.Parameters.Add "PV_ID", 	rsQry("pv_id"),		ORAPARM_INPUT, ORATYPE_NUMBER
77 
	Set rsPD = OraDatabase.DbCreateDynaset( GetQuery ("pd_patch.sql"), ORADYN_DEFAULT )
80 
	Set rsPD = OraDatabase.DbCreateDynaset( GetQuery ("pd_patch.sql"), ORADYN_DEFAULT )
78
- 
 
79 
%>
81 
%>
80
- 
 
81 
 
 - 
 
82 
  <tr>
 82 
  <tr>
83 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_name")%></div></td>
 83 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_name")%></div></td>
84 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_version")%></div></td>
 84 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsQry("pkg_version")%></div></td>
85 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_name")%></div></td>
 85 
    <td width="50%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_name")%></div></td>
86 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_version")%></div></td>
86 
    <td width="30%" nowrap class="body_row" valign="top"><div align="center"><%=rsPD("pkg_version")%></div></td>
87 
  </tr>
 87 
  </tr>
88 
 
 - 
 
89 
<%
88 
<%
90 
	OraDatabase.Parameters.Remove "PV_ID"
89 
	OraDatabase.Parameters.Remove "PV_ID"
91 
		rsPD.Close()
 90 
		rsPD.Close()
92 
		Set rsPD = nothing
 91 
		Set rsPD = nothing
93 
		rsQry.MoveNext
92 
		rsQry.MoveNext
Line 101... Line 100...
101
100
102 
		rsQry.Close()
 101 
		rsQry.Close()
103 
		Set rsQry = nothing
 102 
		Set rsQry = nothing
104 
%>
 103 
%>
105 
</table>
 104 
</table>
106 
 
 - 
 
107 
 
 - 
 
108 
 
 - 
 
109 
 
 - 
 
110 
 
 - 
 
111 
 
 - 
 
112 
 
 - 
 
113 
</body>
 105 
</body>
114 
</html>
 106 
</html>
115 
<%
 107 
<%
116 
'------------ RUN AFTER PAGE RENDER -----------
 108 
'------------ RUN AFTER PAGE RENDER -----------
117 
 
 109