Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
5071 dpurdie 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'   sdk_remove_release.asp
5
'   Remove zero or more SDKs from a Release
6
'=====================================================
7
%>
8
<%
9
Option explicit
10
' Good idea to set when using redirect
11
Response.Expires = 0   ' always load the page, dont store
12
%>
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
<!--#include file="common/common_dbedit.asp"-->
20
<%
21
'------------ ACCESS CONTROL ------------------
22
%>
23
<!--#include file="_access_control_login.asp"-->
24
<!--#include file="_access_control_general.asp"-->
25
<!--#include file="_access_control_project.asp"-->
26
<%
27
'------------ Variable Definition -------------
28
Dim ProblemsString
29
Dim OverideWarnings
30
'------------ Constants Declaration -----------
31
'------------ Variable Init -------------------
32
ProblemsString = NULL
33
 
34
OverideWarnings = "N"
35
If InStr( 1, Request("btn"), "YES", 1 ) > 0 Then OverideWarnings = "Y"
36
 
37
'----------------------------------------------
38
%>
39
<%
40
Sub RemoveReleaseSdk   ( nRtagId, nSdktagId, outProblemsString )
41
 
42
   OraDatabase.Parameters.Add "RTAG_ID",     nRtagId,   ORAPARM_INPUT, ORATYPE_NUMBER
43
   OraDatabase.Parameters.Add "SDKTAG_ID",   nSdktagId, ORAPARM_INPUT, ORATYPE_NUMBER
44
 
45
   objEH.TryORA ( OraSession )
46
   On Error Resume Next
47
 
48
   OraDatabase.ExecuteSQL _
49
   " BEGIN "&_
50
   "    PK_RELEASE.REMOVE_RELEASE_SDK ( :RTAG_ID, :SDKTAG_ID ); "&_
51
   " END; "
52
 
53
   objEH.CatchORA ( OraSession )
54
 
55
   OraDatabase.Parameters.Remove "RTAG_ID"
56
   OraDatabase.Parameters.Remove "SDKTAG_ID"
57
End Sub
58
%>
59
<%
60
'-----------------------  MAIN LINE  ---------------------------
61
 
62
'------ ACCESS CONTROL ----------
63
'If NOT canShowControlInProject("RemoveReleaseSdk") Then
64
'   Call OpenInWindow ( "Login.asp?message=4&rfile="& scriptName & objPMod.ComposeURLWithout("rfile") )
65
'End If
66
'--------------------------------
67
 
68
If (Request("rtag_id") <> "") Then
69
 
70
   '    May have zero or more SDKs to delete
71
   '    Ignore attempts to delete zero SDks
72
   Dim sdktagArray, ii
73
   sdktagArray = Split(Request("sdktag_id"), ",")
74
 
75
    For ii = 0 To UBound(sdktagArray)
76
        Call RemoveReleaseSdk ( Request("rtag_id"), sdktagArray(ii), ProblemsString )
77
    Next
78
 
79
   Response.Redirect( "dependencies.asp?rtag_id="& Request("rtag_id") )
80
 
81
Else
82
 
83
   Err.Raise 8, "This page requires more paramaters to run.<br>"& objPMod.ComposeURL()
84
 
85
End If
86
 
87
'----------------------------------------------------------------
88
%>
89
 
90
<!-- DESTRUCTOR ------->
91
<!--#include file="common/destructor.asp"-->