| Line 30... |
Line 30... |
| 30 |
<!--#include file="_access_control_general.asp"-->
|
30 |
<!--#include file="_access_control_general.asp"-->
|
| 31 |
<!--#include file="_access_control_project.asp"-->
|
31 |
<!--#include file="_access_control_project.asp"-->
|
| 32 |
<%
|
32 |
<%
|
| 33 |
'------------ Variable Definition -------------
|
33 |
'------------ Variable Definition -------------
|
| 34 |
Dim bShowAll
|
34 |
Dim bShowAll
|
| - |
|
35 |
Dim bShowAny
|
| - |
|
36 |
Dim bShowNone
|
| 35 |
Dim sPrevPage
|
37 |
Dim sPrevPage
|
| 36 |
'------------ Constants Declaration -----------
|
38 |
'------------ Constants Declaration -----------
|
| 37 |
|
39 |
|
| 38 |
'------------ Variable Init -------------------
|
40 |
'------------ Variable Init -------------------
|
| 39 |
bShowAll = Request("ShowAll")
|
41 |
bShowAll = Request("ShowAll")
|
| - |
|
42 |
bShowAny = Request("ShowAny")
|
| - |
|
43 |
bShowNone = Request("ShowNone")
|
| 40 |
sPrevPage = QStrParDefault("prevPage", Request.ServerVariables("HTTP_REFERER"))
|
44 |
sPrevPage = QStrParDefault("prevPage", Request.ServerVariables("HTTP_REFERER"))
|
| 41 |
|
45 |
|
| - |
|
46 |
|
| 42 |
'--------------------------------------------------------------------------------------------------------------------------
|
47 |
'--------------------------------------------------------------------------------------------------------------------------
|
| 43 |
' release_licencing_query_string
|
48 |
' release_licencing_query_string
|
| 44 |
'
|
49 |
'
|
| 45 |
' DESCRIPTION
|
50 |
' DESCRIPTION
|
| 46 |
' Constructs a query string using the provided release tag, designed to elicit
|
51 |
' Constructs a query string using the provided release tag, designed to elicit
|
| Line 107... |
Line 112... |
| 107 |
"WHERE pv.pv_id = rc.pv_id " &_
|
112 |
"WHERE pv.pv_id = rc.pv_id " &_
|
| 108 |
"AND pkg.pkg_id = pv.pkg_id " &_
|
113 |
"AND pkg.pkg_id = pv.pkg_id " &_
|
| 109 |
"AND pv.pv_id = lcng.pv_id (+) " &_
|
114 |
"AND pv.pv_id = lcng.pv_id (+) " &_
|
| 110 |
"AND lcng.licence = lcs.licence (+) " &_
|
115 |
"AND lcng.licence = lcs.licence (+) " &_
|
| 111 |
"AND pv.pkg_id = al.pkg_id(+) " &_
|
116 |
"AND pv.pkg_id = al.pkg_id(+) " &_
|
| 112 |
"AND ((lcng.licence is not null) OR ('" & bShowAll & "' is not null)) " &_
|
117 |
"AND ((lcng.licence is not null) OR ('" & bShowAll & "' is not null) OR ( (al.name is not null) AND ('" & bShowAny & "' is not null) )) " &_
|
| 113 |
"ORDER BY Upper( pkg.pkg_name), " &_
|
118 |
"ORDER BY Upper( pkg.pkg_name), " &_
|
| 114 |
" Upper(pv.pkg_version) "
|
119 |
" Upper(pv.pkg_version) "
|
| 115 |
|
120 |
|
| 116 |
End Function
|
121 |
End Function
|
| 117 |
|
122 |
|
| Line 310... |
Line 315... |
| 310 |
</tr>
|
315 |
</tr>
|
| 311 |
<tr>
|
316 |
<tr>
|
| 312 |
<td background="images/bg_action_norm.gif" ></td>
|
317 |
<td background="images/bg_action_norm.gif" ></td>
|
| 313 |
<td align="right" background="images/bg_action_norm.gif" >
|
318 |
<td align="right" background="images/bg_action_norm.gif" >
|
| 314 |
<input name="btn_submit" type="reset" class="form_btn" value="OK", onClick="location.href='<%=sPrevPage%>';">
|
319 |
<input name="btn_submit" type="reset" class="form_btn" value="OK", onClick="location.href='<%=sPrevPage%>';">
|
| 315 |
<%If IsEmpty(bShowAll) Then%>
|
320 |
<%If NOT IsEmpty(bShowNone)Then%>
|
| - |
|
321 |
<input name="showAny" type="submit" class="form_btn" value="Show Any">
|
| - |
|
322 |
<%ElseIf NOT IsEmpty(bShowAny) Then%>
|
| 316 |
<input name="showAll" type="submit" class="form_btn" value="Show All">
|
323 |
<input name="showAll" type="submit" class="form_btn" value="Show All">
|
| 317 |
<%Else%>
|
324 |
<%Else%>
|
| 318 |
<input name="showNone" type="submit" class="form_btn" value="Hide Unspecified">
|
325 |
<input name="showNone" type="submit" class="form_btn" value="Hide Unspecified">
|
| 319 |
<%End If%>
|
326 |
<%End If%>
|
| 320 |
</td>
|
327 |
</td>
|