| Line 31... |
Line 31... |
| 31 |
Set viewinfoHash = CreateObject("Scripting.Dictionary")
|
31 |
Set viewinfoHash = CreateObject("Scripting.Dictionary")
|
| 32 |
parView_id = QStrPar("FRview_id")
|
32 |
parView_id = QStrPar("FRview_id")
|
| 33 |
'----------------------------------------------
|
33 |
'----------------------------------------------
|
| 34 |
%>
|
34 |
%>
|
| 35 |
<%
|
35 |
<%
|
| 36 |
Function Get_All_Pkg_Names
|
36 |
Function Get_All_Pkg_Names
|
| 37 |
Get_All_Pkg_Names = " SELECT pkg_id, pkg_name, UPPER(pkg_name) AS name_order FROM packages WHERE pkg_id > 0 ORDER BY name_order ASC"
|
37 |
Get_All_Pkg_Names = " SELECT pkg_id, pkg_name, UPPER(pkg_name) AS name_order FROM packages WHERE pkg_id > 0 ORDER BY name_order ASC"
|
| 38 |
End Function
|
38 |
End Function
|
| 39 |
|
39 |
|
| 40 |
Sub Populate_viewdefHash ( NNview_id, HHviewdefHash )
|
40 |
Sub Populate_viewdefHash ( NNview_id, HHviewdefHash )
|
| 41 |
Dim rsTemp, Query_String
|
41 |
Dim rsTemp, Query_String
|
| Line 91... |
Line 91... |
| 91 |
<!-- TIPS LAYERS -------------------------------------->
|
91 |
<!-- TIPS LAYERS -------------------------------------->
|
| 92 |
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10"> </div>
|
92 |
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10"> </div>
|
| 93 |
<!----------------------------------------------------->
|
93 |
<!----------------------------------------------------->
|
| 94 |
<form name="newview" method="post" action="<%=scriptName%>?done=done<%=QSTR_All%>" onSubmit="return check();">
|
94 |
<form name="newview" method="post" action="<%=scriptName%>?done=done<%=QSTR_All%>" onSubmit="return check();">
|
| 95 |
<table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
|
95 |
<table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
|
| 96 |
<tr>
|
96 |
<tr>
|
| 97 |
<td background="images/bg_member_dark.gif" width="1%" height="1%"><img src="images/bt_view.gif" width="31" height="18" hspace="5"></td>
|
97 |
<td background="images/bg_member_dark.gif" width="1%" height="1%"><img src="images/bt_view.gif" width="31" height="18" hspace="5"></td>
|
| 98 |
<td background="images/bg_member_dark.gif" nowrap width="50%" class="wform_ttl"> Edit Personal View</td>
|
98 |
<td background="images/bg_member_dark.gif" nowrap width="50%" class="wform_ttl"> Edit Personal View</td>
|
| 99 |
<td background="images/bg_member_dark.gif" align="right" width="50%">
|
99 |
<td background="images/bg_member_dark.gif" align="right" width="50%">
|
| 100 |
<input type="hidden" name="action" value="true">
|
100 |
<input type="hidden" name="action" value="true">
|
| 101 |
<input type="hidden" name="FRview_id" value="<%=parView_id%>">
|
101 |
<input type="hidden" name="FRview_id" value="<%=parView_id%>">
|
| 102 |
<input type="submit" name="btn" value="Update" class="form_btn_comp" onClick="clickedButton=true;MM_validateForm('FRviewname','View Name','R');return document.MM_returnValue">
|
102 |
<input type="submit" name="btn" value="Update" class="form_btn_comp" onClick="clickedButton=true;MM_validateForm('FRviewname','View Name','R');return document.MM_returnValue">
|
| 103 |
<input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
|
103 |
<input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
|
| 104 |
</td>
|
104 |
</td>
|
| 105 |
<td background="images/bg_member_dark.gif" align="right" width="1%%" nowrap>
|
105 |
<td background="images/bg_member_dark.gif" align="right" width="1%%" nowrap>
|
| 106 |
<img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
|
106 |
<img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
|
| 107 |
</tr>
|
107 |
</tr>
|
| 108 |
<tr>
|
108 |
<tr>
|
| 109 |
<td height="100%" width="1%"> </td>
|
109 |
<td height="100%" width="1%"> </td>
|
| 110 |
<td valign="top" nowrap colspan="3" class="wform_ttl">
|
110 |
<td valign="top" nowrap colspan="3" class="wform_ttl">
|
| 111 |
<table width="100%" border="0" cellspacing="1" cellpadding="2">
|
111 |
<table width="100%" border="0" cellspacing="1" cellpadding="2">
|
| 112 |
<tr>
|
112 |
<tr>
|
| 113 |
<td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
|
113 |
<td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
|
| 114 |
<td width="1%" nowrap class="form_group" valign="bottom"></td>
|
114 |
<td width="1%" nowrap class="form_group" valign="bottom"></td>
|
| 115 |
<td nowrap width="100%" align="right" class="form_step"> </td>
|
115 |
<td nowrap width="100%" align="right" class="form_step"> </td>
|
| 116 |
</tr>
|
116 |
</tr>
|
| 117 |
<tr>
|
117 |
<tr>
|
| 118 |
<td width="1%"> </td>
|
118 |
<td width="1%"> </td>
|
| 119 |
<td colspan="2" width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">
|
119 |
<td colspan="2" width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">
|
| 120 |
View Name</td>
|
120 |
View Name</td>
|
| 121 |
</tr>
|
121 |
</tr>
|
| 122 |
<tr>
|
122 |
<tr>
|
| 123 |
<td width="1%"> </td>
|
123 |
<td width="1%"> </td>
|
| 124 |
<td colspan="2" width="1%" nowrap background="images/bg_form_lightgray.gif">
|
124 |
<td colspan="2" width="1%" nowrap background="images/bg_form_lightgray.gif">
|
| 125 |
<input type="text" name="FRviewname" maxlength="30" class="form_item" value="<%=viewinfoHash.Item("view_name")%>">
|
125 |
<input type="text" name="FRviewname" maxlength="30" class="form_item" value="<%=viewinfoHash.Item("view_name")%>">
|
| 126 |
<input type="checkbox" name="FRpubread" value="Y" <%If CStr(viewinfoHash.Item("public_read")) = "Y" Then Response.write "checked"%>><span class="form_item">public read</span><%=Quick_Help("pubread")%></td>
|
126 |
<input type="checkbox" name="FRpubread" value="Y" <%If CStr(viewinfoHash.Item("public_read")) = "Y" Then Response.write "checked"%>><span class="form_item">public read</span><%=Quick_Help("pubread")%></td>
|
| 127 |
</tr>
|
127 |
</tr>
|
| 128 |
<tr>
|
128 |
<tr>
|
| 129 |
<td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="10"></td>
|
129 |
<td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="10"></td>
|
| 130 |
<td width="1%" nowrap class="form_group" valign="bottom"></td>
|
130 |
<td width="1%" nowrap class="form_group" valign="bottom"></td>
|
| 131 |
<td nowrap width="100%" align="right" class="form_step"></td>
|
131 |
<td nowrap width="100%" align="right" class="form_step"></td>
|
| 132 |
</tr>
|
132 |
</tr>
|
| 133 |
<tr>
|
133 |
<tr>
|
| 134 |
<td width="1%"> </td>
|
134 |
<td width="1%"> </td>
|
| 135 |
<td colspan="2" width="1%" nowrap class="form_field">
|
135 |
<td colspan="2" width="1%" nowrap class="form_field">
|
| 136 |
<table width="100%" border="0" cellspacing="1" cellpadding="2">
|
136 |
<table width="100%" border="0" cellspacing="1" cellpadding="2">
|
| 137 |
<tr>
|
137 |
<tr>
|
| 138 |
<td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field"> </td>
|
138 |
<td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field"> </td>
|
| 139 |
<td background="images/bg_form_lightbluedark.gif" nowrap width="100%" class="form_field">Package Name</td>
|
139 |
<td background="images/bg_form_lightbluedark.gif" nowrap width="100%" class="form_field">Package Name</td>
|
| 140 |
</tr>
|
140 |
</tr>
|
| 141 |
<%Set rsTemp = OraDatabase.DbCreateDynaset( Get_All_Pkg_Names, cint(0))
|
141 |
<%Set rsTemp = OraDatabase.DbCreateDynaset( Get_All_Pkg_Names, cint(0))
|
| 142 |
While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
|
142 |
While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
|
| 143 |
<tr>
|
143 |
<tr>
|
| 144 |
<td background="images/bg_form_lightgray.gif" nowrap class="form_item">
|
144 |
<td background="images/bg_form_lightgray.gif" nowrap class="form_item">
|
| 145 |
<input type="checkbox" name="FRpkginc" value="<%=rsTemp.Fields("pkg_id")%>" <%If viewdefHash.Exists (Cstr(rsTemp.Fields("pkg_id"))) Then Response.write "checked"%>>
|
145 |
<input type="checkbox" name="FRpkginc" value="<%=rsTemp.Fields("pkg_id")%>" <%If viewdefHash.Exists (Cstr(rsTemp.Fields("pkg_id"))) Then Response.write "checked"%>>
|
| 146 |
</td>
|
146 |
</td>
|
| 147 |
<td background="images/bg_form_lightgray.gif" class="form_item"><%=rsTemp.Fields("pkg_name")%></td>
|
147 |
<td background="images/bg_form_lightgray.gif" class="form_item"><%=rsTemp.Fields("pkg_name")%></td>
|
| 148 |
</tr>
|
148 |
</tr>
|
| 149 |
<%rsTemp.MoveNext
|
149 |
<%rsTemp.MoveNext
|
| 150 |
WEnd%>
|
150 |
WEnd%>
|
| 151 |
<%If rsTemp.RecordCount < 1 Then%>
|
151 |
<%If rsTemp.RecordCount < 1 Then%>
|
| 152 |
<tr>
|
152 |
<tr>
|
| 153 |
<td background="images/bg_form_lightgray.gif" nowrap class="form_item"></td>
|
153 |
<td background="images/bg_form_lightgray.gif" nowrap class="form_item"></td>
|
| 154 |
<td background="images/bg_form_lightgray.gif" class="err_alert">NO PACKAGES FOUND!</td>
|
154 |
<td background="images/bg_form_lightgray.gif" class="err_alert">NO PACKAGES FOUND!</td>
|
| 155 |
</tr>
|
155 |
</tr>
|
| 156 |
<%End If%>
|
156 |
<%End If%>
|
| 157 |
</table>
|
157 |
</table>
|
| 158 |
</td>
|
158 |
</td>
|
| 159 |
</tr>
|
159 |
</tr>
|
| 160 |
</table>
|
160 |
</table>
|
| 161 |
</td>
|
161 |
</td>
|
| 162 |
</tr>
|
162 |
</tr>
|
| 163 |
<tr>
|
163 |
<tr>
|
| 164 |
<td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
|
164 |
<td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
|
| 165 |
<td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_member_dark.gif"></td>
|
165 |
<td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_member_dark.gif"></td>
|
| 166 |
</tr>
|
166 |
</tr>
|
| 167 |
</table>
|
167 |
</table>
|
| 168 |
</form>
|
168 |
</form>
|
| 169 |
</body>
|
169 |
</body>
|
| 170 |
</html>
|
170 |
</html>
|
| - |
|
171 |
<%
|
| - |
|
172 |
Call Destroy_All_Objects
|
| - |
|
173 |
%>
|