Subversion Repositories DevTools

Rev

Rev 6543 | Rev 6827 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
5357 dpurdie 1 
<%@LANGUAGE="VBSCRIPT"%>
2 
<%
3 
'=====================================================
4 
'|                                                   |
5 
'|				        view by package			     |
6 
'|                                                   |
7 
'=====================================================
8 
%>
9 
<%
10 
Option explicit
11 
' Good idea to set when using redirect
12 
Response.Expires = 0	' always load the page, dont store
13 
%>
14 
<!--#include file="common/conf.asp"-->
15 
<!--#include file="common/globals.asp"-->
16 
<!--#include file="common/formating.asp"-->
17 
<!--#include file="common/qstr.asp"-->
18 
<!--#include file="common/common_subs.asp"-->
19 
<%
20 
'------------ ACCESS CONTROL ------------------
21 
%>
6181 dpurdie 22 
<!--#include file="_access_control_login_optional.asp"-->
5357 dpurdie 23 
<!--#include file="_access_control_general.asp"-->
24 
<%
25 
'------------ Variable Definition -------------
26 
Dim rsRep
27 
Dim parKeyword
28 
Dim parBrowse
29 
'------------ Constants Declaration -----------
30 
'------------ Variable Init -------------------
31 
parKeyword = Request("pkgname")
32 
parBrowse = Request("browse")
33 
'----------------------------------------------
34 
%>
35 
<%
36 
'-----------------------------------------------------------------------------------------------------------------------
37 
'-----------------------------------------------------------------------------------------------------------------------
38 
%>
39 
<%
40 
'==================== MAIN LINE ===============================
5957 dpurdie 41 
If (parKeyword = "") AND (parBrowse = "") Then
42 
    Call Destroy_All_Objects
43 
    Response.Redirect ("index.asp")
44 
End If
5357 dpurdie 45 
'==============================================================
46 
%>
47 
<html>
48 
<head>
49 
<title>Release Manager</title>
50 
<link rel="shortcut icon" href="<%=FavIcon%>"/>
51 
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
52 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
6579 dpurdie 53 
<link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
54 
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
55 
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
5357 dpurdie 56 
<!-- DROPDOWN MENUS -->
5983 dpurdie 57 
<!--#include file="_jquery_includes.asp"-->
5357 dpurdie 58 
<!--#include file="_menu_def.asp"-->
6579 dpurdie 59 
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
5357 dpurdie 60 
</head>
61 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
62 
<!-- HEADER -->
63 
<!--#include file="_header.asp"-->
64 
<!-- BODY ---->
65 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
66 
  <tr>
67 
    <td width="1%" background="images/bg_home_orange.gif" valign="top">
68 
      <!--#include file="_front_explorer.asp"-->
69 
    </td>
70 
    <td rowspan="2" width="1%" valign="top">
71 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
72 
        <tr>
73 
          <td width="1%">
74 
 
75 
		  <table width="100%" border="0" cellspacing="0" cellpadding="0">
76 
			<tr>
77 
			  <td width="1%"></td>
78 
			  <td width="100%" align="right"><img src="images/h_trsp_dot.gif" width="1" height="20"></td>
79 
			  <td width="1%"></td>
80 
			</tr>
81 
			<tr>
82 
			  <td width="1%" bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="480"></td>
83 
			  <td bgcolor="#FFFFFF" valign="top">
84 
				<!-- PACKAGE SEARCH ------------------------------------------------>
85 
				<%
86 
				  OraDatabase.Parameters.Add "KEYWORD", Trim(parKeyword), ORAPARM_INPUT, ORATYPE_VARCHAR2
87 
				  OraDatabase.Parameters.Add "BROWSE", parBrowse, ORAPARM_INPUT, ORATYPE_VARCHAR2
88 
 
89 
				  If parBrowse = "" Then
90 
				  		Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("FindPackageName.sql"), 0 )
91 
				  Else
92 
				  		Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("BrowsePackageName.sql"), 0 )
93 
				  End If
94 
 
95 
				  OraDatabase.Parameters.Remove "KEYWORD"
96 
				  OraDatabase.Parameters.Remove "BROWSE"
97 
				%>
98 
 
99 
				<table width="100%"  border="0" cellspacing="0" cellpadding="5">
100 
                  <tr>
6543 dpurdie 101 
                    <td nowrap bgcolor="#E4E9EC" class="body_txt">Search by Package&nbsp;
5357 dpurdie 102 
					<%If parBrowse <> "" Then%>
103 
						Index <b><%=parBrowse%></b>
104 
					<%Else%>
105 
						Results for <b><%=parKeyword%></b>
106 
					<%End If%>
107 
					</td>
108 
                  </tr>
109 
                </table>
110 
 
111 
 
112 
 
113 
				<table width="100%" border="0" cellspacing="1" cellpadding="5">
114 
				  <%
115 
				  If rsRep.RecordCount = 0 Then
116 
					With Response
117 
						.write "<tr>"
6543 dpurdie 118 
						.write "<td class='body_row nowrap'>Your search <b>"& parKeyword &"</b> did not match any packages.</td>"
5357 dpurdie 119 
						.write "</tr>"
120 
					End With
6543 dpurdie 121 
                  Else %>
122 
				  <tr class="form_field_bg">
123 
                    <td style="min-width:500px" class="body_txt">Package Name</td>
124 
                  </tr>
125 
                  <%
5357 dpurdie 126 
				  End If
127 
 
128 
				  While ((NOT rsRep.BOF) AND (NOT rsRep.EOF)) %>
129 
					  <tr>
130 
						<td nowrap class="body_row" valign="top" bgcolor="#F5F5F5"><a href="view_by_version.asp?pkg_id=<%=rsRep("pkg_id")%>&listby=<%=parListBy%>" class="body_link"><%=Highlight_Substring( rsRep("pkg_name"), parKeyword )%></a></td>
131 
					  </tr>
132 
				  <%  rsRep.MoveNext
133 
				  WEnd
134 
 
135 
				  rsRep.Close()
136 
				  %>
137 
				  <tr>
138 
					<td background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>
139 
				  </tr>
140 
				</table>
141 
				<br>
142 
				<!------------------------------------------------------------>
143 
 
144 
 
145 
				</td>
146 
			  <td width="1%" background="images/lbox_bgside_white.gif">&nbsp;</td>
147 
			</tr>
148 
		  </table>
149 
 
150 
		  </td>
151 
        </tr>
152 
      </table>
153 
    </td>
154 
    <td width="100%">&nbsp;</td>
155 
  </tr>
156 
  <tr>
157 
    <td valign="bottom" align="center" background="images/bg_home_orange.gif"><img src="images/img_gear.gif" width="107" height="107" vspace="20" hspace="30"></td>
158 
    <td>&nbsp;</td>
159 
  </tr>
160 
</table>
161 
<!-- FOOTER -->
162 
<!--#include file="_footer.asp"-->
163 
</body>
164 
</html>