Subversion Repositories DevTools

<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'|                                                   |
'|                 RequestReleaseCombo.asp       |
'|                                                   |
'=====================================================
%>
<%
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"-->
<!--#include file="common/_rtree_common.asp"-->
<%
'------------ Variable Definition -------------
Dim rsQry, Query_String
Dim OutString, parProjId
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
parProjId = Request("proj_id")
'----------------------------------------------
%>
<%
'------------------------------------------------------------------------------------------------------------------------
'------------------------------------------------------------------------------------------------------------------------
%>
<%
'------------------------ MAIN LINE ---------------------------------
If (Request("proj_id")="") Then
        Response.write "ERROR: Missing Parameters at "& ScriptName
End If
'--------------------------------------------------------------------
%>

        <%

                Query_String = _
                " SELECT DISTINCT PKG.PKG_ID, PKG.PKG_NAME FROM RELEASE_CONTENT RC,"&_
                " RELEASE_TAGS RT, PROJECTS PRJ,"&_
                " PACKAGE_VERSIONS PV, PACKAGES PKG"&_
                " WHERE RC.RTAG_ID = RT.RTAG_ID AND PRJ.PROJ_ID = RT.PROJ_ID AND PKG.PKG_ID NOT IN"&_
                " (SELECT PKG_ID FROM PACKAGE_INTEREST WHERE PROJ_ID ="& parProjId &" AND USER_ID ="& objAccessControl.UserId &")"&_
                " AND PV.PV_ID = RC.PV_ID AND PKG.PKG_ID = PV.PKG_ID AND PRJ.PROJ_ID="& parProjId &" order by pkg.pkg_name"
                  
                 Set rsQry = OraDatabase.DbCreateDynaset( Query_String , cint(0) )      
        
        

        
        
        OutString = NULL
        
        
        While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
                OutString = OutString & rsQry("pkg_name") &"|-|"& rsQry("pkg_id")  &"|+|"
                rsQry.MoveNext
        WEnd
        
        
        If NOT IsNull( OutString ) Then
                ' Remove last ;
                OutString = Left( OutString, Len(OutString) - 3 )
        End If
        
        rsQry.Close
        Set rsQry = Nothing
        
        ' Render output
        Response.write OutString
        %>
          
<%
Call Destroy_All_Objects
%>