Subversion Repositories DevTools

Rev

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

Rev 5299 Rev 5354
Line 1... Line 1...
1
<%@LANGUAGE="VBSCRIPT"%>
1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
2
<%
3
'=====================================================
3
'=====================================================
4
'|                                                   |
4
'|                                                   |
5
'|			          wAddApplicationUser		 	 |
5
'|			          wAddApplicationUser		 	 |
6
'|                                                   |
6
'|                                                   |
7
'=====================================================
7
'=====================================================
8
%>
8
%>
9
<%
9
<%
10
Option explicit
10
Option explicit
11
Response.Expires = 0
11
Response.Expires = 0
12
%>
12
%>
13
<!--#include file="common/globals.asp"-->
13
<!--#include file="common/globals.asp"-->
14
<!--#include file="common/config.asp"-->
14
<!--#include file="common/config.asp"-->
15
<!--#include file="common/common_subs.asp"-->
15
<!--#include file="common/common_subs.asp"-->
16
<!--#include file="common/_popup_window_common.asp"-->
16
<!--#include file="common/_popup_window_common.asp"-->
17
<%
17
<%
18
'------------ ACCESS CONTROL ------------------
18
'------------ ACCESS CONTROL ------------------
19
%>
19
%>
20
<!--#include file="_access_control_general.asp"-->
20
<!--#include file="_access_control_general.asp"-->
21
<%
21
<%
22
'------------ VARIABLE DEFINITION -------------
22
'------------ VARIABLE DEFINITION -------------
23
Dim rsUser
23
Dim rsUser
24
Dim objFormCollector
24
Dim objFormCollector
25
'------------ CONSTANTS DECLARATION -----------
25
'------------ CONSTANTS DECLARATION -----------
26
'------------ VARIABLE INIT -------------------
26
'------------ VARIABLE INIT -------------------
27
Set objFormCollector = CreateObject("Scripting.Dictionary")
27
Set objFormCollector = CreateObject("Scripting.Dictionary")
28
'------------ CONDITIONS ----------------------
28
'------------ CONDITIONS ----------------------
29
'----------------------------------------------
29
'----------------------------------------------
30
%>
30
%>
31
<%
31
<%
32
'--------------------------------------------------------------------------------------------------------------------------
32
'--------------------------------------------------------------------------------------------------------------------------
33
Sub AddApplicationUser ()
33
Sub AddApplicationUser ()
34
	On Error Resume Next
34
	On Error Resume Next
35
	
35
	
36
	OraDatabase.Parameters.Add "USER_ID_LIST", 		Request("user_id_list"), 	ORAPARM_INPUT, ORATYPE_VARCHAR2
36
	OraDatabase.Parameters.Add "USER_ID_LIST", 		Request("user_id_list"), 	ORAPARM_INPUT, ORATYPE_VARCHAR2
37
	OraDatabase.Parameters.Add "APP_ID", 			Request("app_id"), 			ORAPARM_INPUT, ORATYPE_NUMBER
37
	OraDatabase.Parameters.Add "APP_ID", 			Request("app_id"), 			ORAPARM_INPUT, ORATYPE_NUMBER
38
	OraDatabase.Parameters.Add "INCLUDE_EVERYONE", 	Request("everyone"), 		ORAPARM_INPUT, ORATYPE_CHAR
38
	OraDatabase.Parameters.Add "INCLUDE_EVERYONE", 	Request("everyone"), 		ORAPARM_INPUT, ORATYPE_CHAR
39
	
39
	
40
	
40
	
41
	objEH.TryORA ( OraSession )
41
	objEH.TryORA ( OraSession )
42
	
42
	
43
	OraDatabase.ExecuteSQL _
43
	OraDatabase.ExecuteSQL _
44
	"BEGIN pk_User.Add_Application_User ( :USER_ID_LIST, :APP_ID, :INCLUDE_EVERYONE ); END;"	
44
	"BEGIN pk_User.Add_Application_User ( :USER_ID_LIST, :APP_ID, :INCLUDE_EVERYONE ); END;"	
45
	
45
	
46
	objEH.CatchORA ( OraSession )
46
	objEH.CatchORA ( OraSession )
47
	
47
	
48
	
48
	
49
	OraDatabase.Parameters.Remove "USER_ID_LIST"
49
	OraDatabase.Parameters.Remove "USER_ID_LIST"
50
	OraDatabase.Parameters.Remove "APP_ID"
50
	OraDatabase.Parameters.Remove "APP_ID"
51
	OraDatabase.Parameters.Remove "INCLUDE_EVERYONE"
51
	OraDatabase.Parameters.Remove "INCLUDE_EVERYONE"
52
	
52
	
53
End Sub
53
End Sub
54
'--------------------------------------------------------------------------------------------------------------------------
54
'--------------------------------------------------------------------------------------------------------------------------
55
%>
55
%>
56
<%
56
<%
57
'------------ RUN BEFORE PAGE RENDER ----------
57
'------------ RUN BEFORE PAGE RENDER ----------
58
' --- Get Form details from DB (for edit forms only) ---
58
' --- Get Form details from DB (for edit forms only) ---
59
'-------------------------------------------------------
59
'-------------------------------------------------------
60
 
60
 
61
' --- Load Validation Rules ---
61
' --- Load Validation Rules ---
62
 
62
 
63
 
63
 
64
' --- Enter Form Validation Rule Changes here... ----
64
' --- Enter Form Validation Rule Changes here... ----
65
'----------------------------------------------------
65
'----------------------------------------------------
66
 
66
 
67
If CBool(Request("action")) Then
67
If CBool(Request("action")) Then
68
	If objForm.IsValidOnPostBack Then
68
	If objForm.IsValidOnPostBack Then
69
		' --- Form is Valid ---
69
		' --- Form is Valid ---
70
		Call AddApplicationUser()
70
		Call AddApplicationUser()
71
		
71
		
72
		If objEH.Finally Then
72
		If objEH.Finally Then
73
			Call OpenInParentWindow ( Request("rfile") &"?"& objPMod.ComposeURL() )
73
			Call OpenInParentWindow ( Request("rfile") &"?"& objPMod.ComposeURL() )
74
			Call CloseWindow()
74
			Call CloseWindow()
75
		End If
75
		End If
76
		
76
		
77
	End If
77
	End If
78
End If
78
End If
79
'----------------------------------------------
79
'----------------------------------------------
80
%>
80
%>
81
<html>
81
<html>
82
<head>
82
<head>
83
<title>Access Manager</title>
83
<title>Access Manager</title>
84
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
84
<link rel="shortcut icon" href="<%=FavIcon%>"/>
85
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
85
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
86
<link href="scripts/access_manager.css" rel="stylesheet" type="text/css">
86
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
87
<script language="JavaScript" src="scripts/common.js"></script>
87
<link href="scripts/access_manager.css" rel="stylesheet" type="text/css">
88
</head>
88
<script language="JavaScript" src="scripts/common.js"></script>
89
 
89
</head>
90
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" onLoad="self.focus();">
90
 
91
<table width="100%"  border="0" cellspacing="0" cellpadding="10">
91
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" onLoad="self.focus();">
92
  <tr>
92
<table width="100%"  border="0" cellspacing="0" cellpadding="10">
93
    <td bgcolor="#FFFFFF" class="body_txt"><span class="body_h1"><img src="images/i_user_lrg.gif" width="13" height="17" hspace="0" align="absmiddle">&nbsp;Add User </span> <br>
93
  <tr>
94
    Search for User or select from the list. </td>
94
    <td bgcolor="#FFFFFF" class="body_txt"><span class="body_h1"><img src="images/i_user_lrg.gif" width="13" height="17" hspace="0" align="absmiddle">&nbsp;Add User </span> <br>
95
  </tr>
95
    Search for User or select from the list. </td>
96
  <form name="FormSearch" method="post" action="<%=SCRIPT_NAME%>">
96
  </tr>
97
  <tr>
97
  <form name="FormSearch" method="post" action="<%=SCRIPT_NAME%>">
98
    <td background="images/bg_quicksearch.gif" class="body_txt"><table width="100" border="0" cellspacing="3" cellpadding="0">
98
  <tr>
99
        <tr>
99
    <td background="images/bg_quicksearch.gif" class="body_txt"><table width="100" border="0" cellspacing="3" cellpadding="0">
100
          <td nowrap class="body_txtw"><strong>User Search</strong> </td>
100
        <tr>
101
          <td><input name="filter" type="text" class="body_txt" size="20" value="<%=Request("filter")%>"></td>
101
          <td nowrap class="body_txtw"><strong>User Search</strong> </td>
102
          <td><input name="btn" type="image" src="images/b_search.gif" width="16" height="16" border="0"></td>
102
          <td><input name="filter" type="text" class="body_txt" size="20" value="<%=Request("filter")%>"></td>
103
        </tr>
103
          <td><input name="btn" type="image" src="images/b_search.gif" width="16" height="16" border="0"></td>
104
      </table></td>
104
        </tr>
105
  </tr>
105
      </table></td>
106
  <%=objPMod.ComposeHiddenTags()%>
106
  </tr>
107
  </form>
107
  <%=objPMod.ComposeHiddenTags()%>
108
  <form name="FormName" method="post" action="<%=SCRIPT_NAME%>">
108
  </form>
109
  <tr>
109
  <form name="FormName" method="post" action="<%=SCRIPT_NAME%>">
110
    <td background="images/bg_drk_bage_pane.gif">
110
  <tr>
111
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
111
    <td background="images/bg_drk_bage_pane.gif">
112
      <tr>
112
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
113
        <td>&nbsp;</td>
113
      <tr>
114
        <td align="right"><input name="btn" type="submit" class="form_btn" value="Add">
114
        <td>&nbsp;</td>
115
          <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="self.close();"></td>
115
        <td align="right"><input name="btn" type="submit" class="form_btn" value="Add">
116
      </tr>
116
          <input name="btn" type="reset" class="form_btn" value="Cancel" onClick="self.close();"></td>
117
    </table></td>
117
      </tr>
118
  </tr>
118
    </table></td>
119
  <tr>
119
  </tr>
120
    <td>
120
  <tr>
121
 
121
    <td>
122
		<table width="300"  border="0" cellspacing="2" cellpadding="0">
122
 
123
          <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
123
		<table width="300"  border="0" cellspacing="2" cellpadding="0">
124
          <%If NOT objEH.Finally Then%>
124
          <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
125
          <tr>
125
          <%If NOT objEH.Finally Then%>
126
            <td>
126
          <tr>
127
              <%objEH.DisplayMessage()%>
127
            <td>
128
            </td>
128
              <%objEH.DisplayMessage()%>
129
          </tr>
129
            </td>
130
          <%End If%>
130
          </tr>
131
          <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
131
          <%End If%>
132
        </table>
132
          <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
133
		
133
        </table>
134
<%
134
		
135
		Dim startPosition, pageNumber, navigator, totalRecords, lastRecord
135
<%
136
		Const MAX_ROWS = 50	' Maximum number of rows displayed
136
		Dim startPosition, pageNumber, navigator, totalRecords, lastRecord
137
		
137
		Const MAX_ROWS = 50	' Maximum number of rows displayed
138
		OraDatabase.Parameters.Add "APP_ID", 			Request("app_id"), 			ORAPARM_INPUT, ORATYPE_NUMBER
138
		
139
		
139
		OraDatabase.Parameters.Add "APP_ID", 			Request("app_id"), 			ORAPARM_INPUT, ORATYPE_NUMBER
140
		'--- Set filters ---
140
		
141
		If Request("filter") <> "" Then
141
		'--- Set filters ---
142
			OraDatabase.Parameters.Add "FULL_NAME", 	"%"& Request("filter") &"%",	ORAPARM_INPUT, ORATYPE_VARCHAR2
142
		If Request("filter") <> "" Then
143
			OraDatabase.Parameters.Add "USER_NAME", 	Request("filter") &"%",			ORAPARM_INPUT, ORATYPE_VARCHAR2
143
			OraDatabase.Parameters.Add "FULL_NAME", 	"%"& Request("filter") &"%",	ORAPARM_INPUT, ORATYPE_VARCHAR2
144
			OraDatabase.Parameters.Add "DOMAIN_NAME", 	Request("filter") &"%",			ORAPARM_INPUT, ORATYPE_VARCHAR2
144
			OraDatabase.Parameters.Add "USER_NAME", 	Request("filter") &"%",			ORAPARM_INPUT, ORATYPE_VARCHAR2
145
		Else
145
			OraDatabase.Parameters.Add "DOMAIN_NAME", 	Request("filter") &"%",			ORAPARM_INPUT, ORATYPE_VARCHAR2
146
			OraDatabase.Parameters.Add "FULL_NAME", 	NULL,	ORAPARM_INPUT, ORATYPE_VARCHAR2
146
		Else
147
			OraDatabase.Parameters.Add "USER_NAME", 	NULL,	ORAPARM_INPUT, ORATYPE_VARCHAR2
147
			OraDatabase.Parameters.Add "FULL_NAME", 	NULL,	ORAPARM_INPUT, ORATYPE_VARCHAR2
148
			OraDatabase.Parameters.Add "DOMAIN_NAME", 	NULL,	ORAPARM_INPUT, ORATYPE_VARCHAR2
148
			OraDatabase.Parameters.Add "USER_NAME", 	NULL,	ORAPARM_INPUT, ORATYPE_VARCHAR2
149
		End If
149
			OraDatabase.Parameters.Add "DOMAIN_NAME", 	NULL,	ORAPARM_INPUT, ORATYPE_VARCHAR2
150
		
150
		End If
151
		
151
		
152
		Set rsUser = OraDatabase.DbCreateDynaset( GetQuery ("GetApplicationUserList.sql") , ORADYN_DEFAULT )
152
		
153
		
153
		Set rsUser = OraDatabase.DbCreateDynaset( GetQuery ("GetApplicationUserList.sql") , ORADYN_DEFAULT )
154
		OraDatabase.Parameters.Remove "APP_ID"
154
		
155
		OraDatabase.Parameters.Remove "FULL_NAME"
155
		OraDatabase.Parameters.Remove "APP_ID"
156
		OraDatabase.Parameters.Remove "USER_NAME"
156
		OraDatabase.Parameters.Remove "FULL_NAME"
157
		OraDatabase.Parameters.Remove "DOMAIN_NAME"
157
		OraDatabase.Parameters.Remove "USER_NAME"
158
		
158
		OraDatabase.Parameters.Remove "DOMAIN_NAME"
159
		
159
		
160
		'--- Get page number ---
160
		
161
		pageNumber = 0
161
		'--- Get page number ---
162
		If Request("pg") <> "" Then 
162
		pageNumber = 0
163
		pageNumber = CInt(Request("pg"))
163
		If Request("pg") <> "" Then 
164
		End If
164
		pageNumber = CInt(Request("pg"))
165
		
165
		End If
166
		
166
		
167
		'--- Set Cursor start position ---
167
		
168
		startPosition = pageNumber * MAX_ROWS + 1
168
		'--- Set Cursor start position ---
169
		If (NOT rsUser.BOF) AND (NOT rsUser.EOF) Then
169
		startPosition = pageNumber * MAX_ROWS + 1
170
			rsUser.MoveTo ( startPosition )		' Set starting cursor point
170
		If (NOT rsUser.BOF) AND (NOT rsUser.EOF) Then
171
			
171
			rsUser.MoveTo ( startPosition )		' Set starting cursor point
172
		End If
172
			
173
		
173
		End If
174
		
174
		
175
		'--- Construct Navigator
175
		
176
		navigator = ""
176
		'--- Construct Navigator
177
		If (NOT rsUser.BOF) AND (NOT rsUser.EOF) Then
177
		navigator = ""
178
			totalRecords = rsUser.RecordCount	' Get total number of records
178
		If (NOT rsUser.BOF) AND (NOT rsUser.EOF) Then
179
			
179
			totalRecords = rsUser.RecordCount	' Get total number of records
180
			'--- Create "Previous" link
180
			
181
			If pageNumber > 0 Then
181
			'--- Create "Previous" link
182
				navigator = navigator &"<a href='"& SCRIPT_NAME &"?pg="& pageNumber - 1 &"&"& objPMod.ComposeURL &"' class='body_link' title='Show Previous Page'>&laquo; Previous</a>"
182
			If pageNumber > 0 Then
183
			End If
183
				navigator = navigator &"<a href='"& SCRIPT_NAME &"?pg="& pageNumber - 1 &"&"& objPMod.ComposeURL &"' class='body_link' title='Show Previous Page'>&laquo; Previous</a>"
184
			
184
			End If
185
			'--- Create "Next" link
185
			
186
			If ( startPosition + MAX_ROWS ) < totalRecords Then
186
			'--- Create "Next" link
187
				navigator = navigator &"&nbsp;&nbsp;<a href='"& SCRIPT_NAME &"?pg="& pageNumber + 1 &"&"& objPMod.ComposeURL &"' class='body_link' title='Show Next Page'>Next &raquo;</a>"
187
			If ( startPosition + MAX_ROWS ) < totalRecords Then
188
			End If
188
				navigator = navigator &"&nbsp;&nbsp;<a href='"& SCRIPT_NAME &"?pg="& pageNumber + 1 &"&"& objPMod.ComposeURL &"' class='body_link' title='Show Next Page'>Next &raquo;</a>"
189
			
189
			End If
190
		End If
190
			
191
		
191
		End If
192
		
192
		
193
		'--- Calculate Last Record ---
193
		
194
		If totalRecords > 0 Then
194
		'--- Calculate Last Record ---
195
			lastRecord = ( startPosition - 1 + MAX_ROWS ) _
195
		If totalRecords > 0 Then
196
						+ ( CInt( ( startPosition - 1 + MAX_ROWS )/totalRecords > 1) ) * ( ( startPosition - 1 + MAX_ROWS ) - totalRecords )
196
			lastRecord = ( startPosition - 1 + MAX_ROWS ) _
197
		End If
197
						+ ( CInt( ( startPosition - 1 + MAX_ROWS )/totalRecords > 1) ) * ( ( startPosition - 1 + MAX_ROWS ) - totalRecords )
198
		%>
198
		End If
199
		<table width="100%"  border="0" cellspacing="0" cellpadding="0">
199
		%>
200
          <tr align="left">
200
		<table width="100%"  border="0" cellspacing="0" cellpadding="0">
201
            <td colspan="2" class="body_row">&nbsp;</td>
201
          <tr align="left">
202
          </tr>
202
            <td colspan="2" class="body_row">&nbsp;</td>
203
          <tr>
203
          </tr>
204
            <td align="left" class="body_row">
204
          <tr>
205
			<%
205
            <td align="left" class="body_row">
206
			If totalRecords > 0 Then 
206
			<%
207
				Response.write "Showing "& startPosition &" - "& lastRecord &" of "& totalRecords
207
			If totalRecords > 0 Then 
208
			Else
208
				Response.write "Showing "& startPosition &" - "& lastRecord &" of "& totalRecords
209
				Response.write "No Results."
209
			Else
210
			End If
210
				Response.write "No Results."
211
			%></td>
211
			End If
212
            <td align="right" class="body_scol"><%=navigator%></td>
212
			%></td>
213
          </tr>
213
            <td align="right" class="body_scol"><%=navigator%></td>
214
        </table>          
214
          </tr>
215
		 <!-- DETAILS ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
215
        </table>          
216
		 <table width="100%"  border="0" cellspacing="3" cellpadding="0">
216
		 <!-- DETAILS ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
217
          <tr>
217
		 <table width="100%"  border="0" cellspacing="3" cellpadding="0">
218
		  	<td width="1%" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="16" height="16" hspace="2"></td>
218
          <tr>
219
            <td width="30%" background="images/bg_table_border.gif">
219
		  	<td width="1%" background="images/bg_table_col.gif"><img src="images/spacer.gif" width="16" height="16" hspace="2"></td>
220
			<table width="100%"  border="0" cellspacing="1" cellpadding="2">
220
            <td width="30%" background="images/bg_table_border.gif">
221
              <tr>
221
			<table width="100%"  border="0" cellspacing="1" cellpadding="2">
222
                <td align="right" nowrap background="images/bg_table_col.gif" class="body_col">Full Name </td>
222
              <tr>
223
              </tr>
223
                <td align="right" nowrap background="images/bg_table_col.gif" class="body_col">Full Name </td>
224
            </table></td>
224
              </tr>
225
            <td width="30%" align="right" nowrap background="images/bg_table_col.gif" class="body_col">User Name</td>
225
            </table></td>
226
            <td width="40%" align="right" nowrap background="images/bg_table_col.gif" class="body_col">Domain</td>
226
            <td width="30%" align="right" nowrap background="images/bg_table_col.gif" class="body_col">User Name</td>
227
          </tr>
227
            <td width="40%" align="right" nowrap background="images/bg_table_col.gif" class="body_col">Domain</td>
228
		  <%If (Request("filter") = "") AND (rsUser.RecordCount > 0) Then%>
228
          </tr>
229
		  <tr>
229
		  <%If (Request("filter") = "") AND (rsUser.RecordCount > 0) Then%>
230
		  	<td align="center" background="images/bg_table_col.gif"><input type="checkbox" name="everyone" value="Y"></td>
230
		  <tr>
231
            <td nowrap class="body_row" background="images/bg_table_col.gif"><img src="images/i_accounts.gif" width="16" height="14" border="0" hspace="4" align="absmiddle">Everyone</td>
231
		  	<td align="center" background="images/bg_table_col.gif"><input type="checkbox" name="everyone" value="Y"></td>
232
            <td background="images/bg_table_col.gif"></td>
232
            <td nowrap class="body_row" background="images/bg_table_col.gif"><img src="images/i_accounts.gif" width="16" height="14" border="0" hspace="4" align="absmiddle">Everyone</td>
233
			<td background="images/bg_table_col.gif"></td>
233
            <td background="images/bg_table_col.gif"></td>
234
          </tr>
234
			<td background="images/bg_table_col.gif"></td>
235
		  <%End If%>
235
          </tr>
236
		  <%
236
		  <%End If%>
237
		  '--- Render rows ---
237
		  <%
238
		  Do While (NOT rsUser.BOF) AND (NOT rsUser.EOF)
238
		  '--- Render rows ---
239
		  		If rsUser.RowPosition => (startPosition + MAX_ROWS) Then Exit Do	' Limit the number of rows displayed
239
		  Do While (NOT rsUser.BOF) AND (NOT rsUser.EOF)
240
		  %>
240
		  		If rsUser.RowPosition => (startPosition + MAX_ROWS) Then Exit Do	' Limit the number of rows displayed
241
          <tr>
241
		  %>
242
		  	<td align="center"><input type="checkbox" name="user_id_list" value="<%=rsUser("user_id")%>" <%If rsUser("user_id") < 1 Then%>disabled<%End If%>></td>
242
          <tr>
243
            <td nowrap class="body_row"><%=Eval( rsUser("user_image") )  &  rsUser("full_name")%></td>
243
		  	<td align="center"><input type="checkbox" name="user_id_list" value="<%=rsUser("user_id")%>" <%If rsUser("user_id") < 1 Then%>disabled<%End If%>></td>
244
            <td class="body_rowg"><%=rsUser("user_name")%></td>
244
            <td nowrap class="body_row"><%=Eval( rsUser("user_image") )  &  rsUser("full_name")%></td>
245
            <td class="body_rowg"><%=rsUser("domain")%></td>
245
            <td class="body_rowg"><%=rsUser("user_name")%></td>
246
          </tr>
246
            <td class="body_rowg"><%=rsUser("domain")%></td>
247
		  <%rsUser.MoveNext%>
247
          </tr>
248
		  
248
		  <%rsUser.MoveNext%>
249
		  <%If (NOT rsUser.BOF) AND (NOT rsUser.EOF) Then%>
249
		  
250
          <tr>
250
		  <%If (NOT rsUser.BOF) AND (NOT rsUser.EOF) Then%>
251
            <td colspan="4" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
251
          <tr>
252
          </tr>
252
            <td colspan="4" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td>
253
		  <%End If%>
253
          </tr>
254
		  
254
		  <%End If%>
255
		  <%
255
		  
256
		  Loop
256
		  <%
257
		  
257
		  Loop
258
		  
258
		  
259
		  
259
		  
260
		  rsUser.Close()
260
		  
261
		  Set rsUser = Nothing
261
		  rsUser.Close()
262
		  %>
262
		  Set rsUser = Nothing
263
          <tr>
263
		  %>
264
            <td colspan="4" background="images/bg_table_border.gif">
264
          <tr>
265
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
265
            <td colspan="4" background="images/bg_table_border.gif">
266
              <tr>
266
			 <table width="100%"  border="0" cellspacing="1" cellpadding="2">
267
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
267
              <tr>
268
              </tr>
268
                <td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td>
269
             </table>
269
              </tr>
270
			</td>
270
             </table>
271
          </tr>
271
			</td>
272
         </table>	 
272
          </tr>
273
		 <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
273
         </table>	 
274
		 <table width="100%"  border="0" cellspacing="0" cellpadding="0">
274
		 <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
275
          <tr>
275
		 <table width="100%"  border="0" cellspacing="0" cellpadding="0">
276
            <td align="right" class="body_scol"><%=navigator%></td>
276
          <tr>
277
          </tr>
277
            <td align="right" class="body_scol"><%=navigator%></td>
278
        </table>		
278
          </tr>
279
		
279
        </table>		
280
		
280
		
281
	</td>
281
		
282
  </tr>
282
	</td>
283
  <%=objPMod.ComposeHiddenTags()%>
283
  </tr>
284
  <input type="hidden" name="action" value="true">
284
  <%=objPMod.ComposeHiddenTags()%>
285
  </form>
285
  <input type="hidden" name="action" value="true">
286
</table>
286
  </form>
287
</body>
287
</table>
288
</html>
288
</body>
289
<%
289
</html>
290
'------------ RUN AFTER PAGE RENDER -----------
290
<%
291
Set objFormCollector = Nothing
291
'------------ RUN AFTER PAGE RENDER -----------
292
'----------------------------------------------
292
Set objFormCollector = Nothing
293
%>
293
'----------------------------------------------
294
<!--#include file="common/globals_destructor.asp"-->
294
%>
-
 
295
<!--#include file="common/globals_destructor.asp"-->