Subversion Repositories DevTools

Rev

Rev 6579 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'|                                                   |
'|                                      view by package                      |
'|                                                   |
'=====================================================
%>
<%
Option explicit
' Good idea to set when using redirect
Response.Expires = 0    ' always load the page, dont store
%>
<!--#include file="common/conf.asp"-->
<!--#include file="common/globals.asp"-->
<!--#include file="common/formating.asp"-->
<!--#include file="common/qstr.asp"-->
<!--#include file="common/common_subs.asp"-->
<%
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_login_optional.asp"-->
<!--#include file="_access_control_general.asp"-->
<%
'------------ Variable Definition -------------
Dim rsRep
Dim parKeyword
Dim parBrowse
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
parKeyword = Request("pkgname")
parBrowse = Request("browse")
'----------------------------------------------
%>
<%
'-----------------------------------------------------------------------------------------------------------------------
'-----------------------------------------------------------------------------------------------------------------------
%>
<%
'==================== MAIN LINE ===============================
If (parKeyword = "") AND (parBrowse = "") Then 
    Call Destroy_All_Objects
    Response.Redirect ("index.asp")
End If
'==============================================================
Sub DisplayCenterPane%>
    <!-- PACKAGE SEARCH ------------------------------------------------>
    <%
      OraDatabase.Parameters.Add "KEYWORD", Trim(parKeyword), ORAPARM_INPUT, ORATYPE_VARCHAR2
      OraDatabase.Parameters.Add "BROWSE", parBrowse, ORAPARM_INPUT, ORATYPE_VARCHAR2
      
      If parBrowse = "" Then
            Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("FindPackageName.sql"), 0 )
      Else
            Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("BrowsePackageName.sql"), 0 )
      End If
      
      OraDatabase.Parameters.Remove "KEYWORD"
      OraDatabase.Parameters.Remove "BROWSE"
    %>
    <table width="100%" border="0" cellspacing="1" cellpadding="5" class="stdGrey" style="padding: 10px;">
        <thead>
            <tr>
                <th class=thin nowrap>Search by Package&nbsp;
                <%If parBrowse <> "" Then%>
                    Index <b><%=parBrowse%></b>
                <%Else%>
                    Results for <b><%=parKeyword%></b> 
                <%End If%>
                </th>
            </tr>
            <%If rsRep.RecordCount <> 0 Then%>
            <tr>
                <th style="min-width:500px">Package Name</th>
            </tr>
            <%End If%>
        </thead>
      <%If rsRep.RecordCount = 0 Then%>
            <tr>
            <td class='nowrap'>Your search for <b>"<%=parKeyword%>"</b> did not match any packages.</td>
            </tr>
      <%
      End If
      
      While ((NOT rsRep.BOF) AND (NOT rsRep.EOF)) %>
          <tr> 
            <td nowrap><a href="view_by_version.asp?pkg_id=<%=rsRep("pkg_id")%>&listby=<%=parListBy%>" class="body_link"><%=Highlight_Substring( rsRep("pkg_name"), parKeyword )%></a></td>
          </tr>
      <%  rsRep.MoveNext
      WEnd
      
      rsRep.Close()
      %>
    </table>
    <!------------------------------------------------------------>                     
<%End Sub%>
<html>
<head>
<title>Release Manager</title>
<link rel="shortcut icon" href="<%=FavIcon%>"/>
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
<!-- DROPDOWN MENUS -->
<!--#include file="_jquery_includes.asp"-->
<!--#include file="_menu_def.asp"-->
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
<!-- HEADER -->
<!--#include file="_header.asp"-->
<!-- BODY ---->
<table class="full_table">
  <tr> 
    <td width="1%" class=panel_bg valign="top">
      <!--#include file="_front_explorer.asp"-->
    </td>
    <td rowspan="2" width="1%" valign="top"> 
        <%Call DisplayCenterPane%>
    </td>
  </tr>
  <tr> 
    <td valign="bottom" align="center" class=panel_bg><img src="images/img_gear.gif" vspace="20" hspace="30"></td>
    <td>&nbsp;</td>
  </tr>
</table>
<!-- FOOTER -->
<!--#include file="_footer.asp"-->
</body>
</html>