Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 119 Rev 129
Line 25... Line 25...
25 
'------------ Constants Declaration -----------
 25 
'------------ Constants Declaration -----------
26 
'------------ Variable Init -------------------
 26 
'------------ Variable Init -------------------
27 
'----------------------------------------------
 27 
'----------------------------------------------
28 
%>
 28 
%>
29 
<%
 29 
<%
30 
Function Get_All_Pkg_Names
30 
Function Get_All_Pkg_Names
31 
	Get_All_Pkg_Names = " SELECT * FROM packages WHERE pkg_id > 0 ORDER BY pkg_name ASC"
 31 
	Get_All_Pkg_Names = " SELECT * FROM packages WHERE pkg_id > 0 ORDER BY pkg_name ASC"
32 
End Function
 32 
End Function
33 
%>
 33 
%>
34 
<%
 34 
<%
35 
'Process submition
 35 
'Process submition
36 
If CBool(QStrPar("action"))  Then
 36 
If CBool(QStrPar("action"))  Then
37
37 
 
38 
	%>
 38 
	%>
39 
	<script language="JavaScript" type="text/javascript">
 39 
	<script language="JavaScript" type="text/javascript">
40 
	window.opener.document.location='_add_new_personal_view.asp?FRviewname=<%=QStrPar("FRviewname")%>&FRpkginc=<%=Request("FRpkginc")%>&FRpubread=<%=QStrPar("FRpubread")%>';
 40 
	window.opener.document.location='_add_new_personal_view.asp?FRviewname=<%=QStrPar("FRviewname")%>&FRpkginc=<%=Request("FRpkginc")%>&FRpubread=<%=QStrPar("FRpubread")%>';
41 
	</script>
41 
	</script>
42 
	<%
 42 
	<%
43 
	Call CloseWindow
 43 
	Call CloseWindow
44 
End If
 44 
End If
45 
%>
 45 
%>
46 
<html>
 46 
<html>
Line 60... Line 60...
60 
<!-- TIPS LAYERS -------------------------------------->
 60 
<!-- TIPS LAYERS -------------------------------------->
61 
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>
 61 
<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>
62 
<!----------------------------------------------------->
 62 
<!----------------------------------------------------->
63 
<form name="newview" method="post" action="<%=scriptName%>?done=done<%=QSTR_All%>" onSubmit="return check();">
 63 
<form name="newview" method="post" action="<%=scriptName%>?done=done<%=QSTR_All%>" onSubmit="return check();">
64 
  <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
 64 
  <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
65 
    <tr>
65 
    <tr>
66 
      <td background="images/bg_member_dark.gif" width="1%" height="1%"><img src="images/bt_view.gif" width="31" height="18" hspace="5"></td>
 66 
      <td background="images/bg_member_dark.gif" width="1%" height="1%"><img src="images/bt_view.gif" width="31" height="18" hspace="5"></td>
67 
      <td background="images/bg_member_dark.gif" nowrap width="50%" class="wform_ttl">&nbsp;Create
67 
      <td background="images/bg_member_dark.gif" nowrap width="50%" class="wform_ttl">&nbsp;Create
68 
        NEW Personal View</td>
 68 
        NEW Personal View</td>
69 
      <td background="images/bg_member_dark.gif" align="right" width="50%">
 69 
      <td background="images/bg_member_dark.gif" align="right" width="50%">
70 
	  	<input type="hidden" name="action" value="true">
70 
	  	<input type="hidden" name="action" value="true">
71 
        <input type="submit" name="btn" value="Create" class="form_btn_comp" onClick="clickedButton=true;MM_validateForm('FRviewname','View Name','R');return document.MM_returnValue">
 71 
        <input type="submit" name="btn" value="Create" class="form_btn_comp" onClick="clickedButton=true;MM_validateForm('FRviewname','View Name','R');return document.MM_returnValue">
72 
        <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
 72 
        <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
73 
      </td>
 73 
      </td>
74 
      <td background="images/bg_member_dark.gif" align="right" width="1%%" nowrap>
74 
      <td background="images/bg_member_dark.gif" align="right" width="1%%" nowrap>
75 
        <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
 75 
        <img src="images/h_trsp_dot.gif" width="5" height="22"> </td>
76 
    </tr>
 76 
    </tr>
77 
    <tr>
77 
    <tr>
78 
      <td height="100%" width="1%">&nbsp;</td>
 78 
      <td height="100%" width="1%">&nbsp;</td>
79 
      <td valign="top" nowrap colspan="3" class="wform_ttl">
79 
      <td valign="top" nowrap colspan="3" class="wform_ttl">
80 
        <table width="100%" border="0" cellspacing="1" cellpadding="2">
 80 
        <table width="100%" border="0" cellspacing="1" cellpadding="2">
81 
          <tr>
81 
          <tr>
82 
            <td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
 82 
            <td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
83 
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
 83 
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
84 
            <td nowrap width="100%" align="right" class="form_step">&nbsp;</td>
 84 
            <td nowrap width="100%" align="right" class="form_step">&nbsp;</td>
85 
          </tr>
 85 
          </tr>
86 
          <tr>
86 
          <tr>
87 
            <td width="1%">&nbsp;</td>
 87 
            <td width="1%">&nbsp;</td>
88 
            <td colspan="2" width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">
88 
            <td colspan="2" width="1%" nowrap class="form_field" background="images/bg_form_lightbluedark.gif">
89 
              View Name</td>
 89 
              View Name</td>
90 
          </tr>
 90 
          </tr>
91 
          <tr>
91 
          <tr>
92 
            <td width="1%">&nbsp;</td>
 92 
            <td width="1%">&nbsp;</td>
93 
            <td colspan="2" width="1%" nowrap background="images/bg_form_lightgray.gif">
93 
            <td colspan="2" width="1%" nowrap background="images/bg_form_lightgray.gif">
94 
              <input type="text" name="FRviewname" maxlength="30" class="form_item">&nbsp;
 94 
              <input type="text" name="FRviewname" maxlength="30" class="form_item">&nbsp;
95 
              <input type="checkbox" name="FRpubread" value="Y"><span class="form_item">public read</span><%=Quick_Help("pubread")%></td>
 95 
              <input type="checkbox" name="FRpubread" value="Y"><span class="form_item">public read</span><%=Quick_Help("pubread")%></td>
96 
          </tr>
 96 
          </tr>
97 
          <tr>
97 
          <tr>
98 
            <td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="10"></td>
 98 
            <td width="1%"><img src="images/h_trsp_dot.gif" width="1" height="10"></td>
99 
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
 99 
            <td width="1%" nowrap class="form_group" valign="bottom"></td>
100 
            <td nowrap width="100%" align="right" class="form_step"></td>
 100 
            <td nowrap width="100%" align="right" class="form_step"></td>
101 
          </tr>
 101 
          </tr>
102 
          <tr>
102 
          <tr>
103 
            <td width="1%">&nbsp;</td>
 103 
            <td width="1%">&nbsp;</td>
104 
            <td colspan="2" width="1%" nowrap class="form_field">
104 
            <td colspan="2" width="1%" nowrap class="form_field">
105 
              <table width="100%" border="0" cellspacing="1" cellpadding="2">
 105 
              <table width="100%" border="0" cellspacing="1" cellpadding="2">
106 
                <tr>
106 
                <tr>
107 
                  <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field">&nbsp;</td>
 107 
                  <td background="images/bg_form_lightbluedark.gif" nowrap width="1%" class="form_field">&nbsp;</td>
108 
                  <td background="images/bg_form_lightbluedark.gif" nowrap width="100%" class="form_field">Package Name</td>
 108 
                  <td background="images/bg_form_lightbluedark.gif" nowrap width="100%" class="form_field">Package Name</td>
109 
                </tr>
 109 
                </tr>
110 
                <%Set rsTemp = OraDatabase.DbCreateDynaset( Get_All_Pkg_Names, cint(0))
 110 
                <%Set rsTemp = OraDatabase.DbCreateDynaset( Get_All_Pkg_Names, cint(0))
111 
				While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
 111 
				While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))%>
112 
                <tr>
112 
                <tr>
113 
                  <td background="images/bg_form_lightgray.gif" nowrap class="form_item">
113 
                  <td background="images/bg_form_lightgray.gif" nowrap class="form_item">
114 
                    <input type="checkbox" name="FRpkginc" value="<%=rsTemp.Fields("pkg_id")%>">
 114 
                    <input type="checkbox" name="FRpkginc" value="<%=rsTemp.Fields("pkg_id")%>">
115 
                  </td>
 115 
                  </td>
116 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><%=rsTemp.Fields("pkg_name")%></td>
 116 
                  <td background="images/bg_form_lightgray.gif" class="form_item"><%=rsTemp.Fields("pkg_name")%></td>
117 
                </tr>
 117 
                </tr>
118 
                <%rsTemp.MoveNext
 118 
                <%rsTemp.MoveNext
119 
			  	WEnd%>
 119 
			  	WEnd%>
120 
				<%If rsTemp.RecordCount < 1 Then%>
 120 
				<%If rsTemp.RecordCount < 1 Then%>
121 
				<tr>
121 
				<tr>
122 
                  <td background="images/bg_form_lightgray.gif" nowrap class="form_item"></td>
 122 
                  <td background="images/bg_form_lightgray.gif" nowrap class="form_item"></td>
123 
                  <td background="images/bg_form_lightgray.gif" class="err_alert">NO PACKAGES FOUND!</td>
 123 
                  <td background="images/bg_form_lightgray.gif" class="err_alert">NO PACKAGES FOUND!</td>
124 
                </tr>
 124 
                </tr>
125 
				<%End If%>
 125 
				<%End If%>
126 
              </table>
 126 
              </table>
127 
            </td>
 127 
            </td>
128 
          </tr>
 128 
          </tr>
129 
        </table>
 129 
        </table>
130 
      </td>
 130 
      </td>
131 
    </tr>
 131 
    </tr>
132 
    <tr>
132 
    <tr>
133 
      <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
 133 
      <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
134 
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_member_dark.gif"></td>
 134 
      <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_member_dark.gif"></td>
135 
    </tr>
 135 
    </tr>
136 
  </table>
 136 
  </table>
137 
</form>
 137 
</form>
138 
</body>
 138 
</body>
139 
</html>
 139 
</html>
- 
 
 140 
<%
- 
 
 141 
Call Destroy_All_Objects
- 
 
 142 
%>