<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'| |
'| MEMBERS |
'| PERSONAL VIEW |
'=====================================================
%>
<%
Option explicit
' Good idea to set when using redirect
Response.Expires = 0 ' always load the page, dont store
%>
<%
'------------ ACCESS CONTROL ------------------
%>
<%
'------------ Variable Definition -------------
Dim rsTemp
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
'----------------------------------------------
%>
<%
Function Get_Personal_Views ( NNuser_id )
Get_Personal_Views = ReadFile( rootPath & "queries\personal_views_list.qry" )
Get_Personal_Views = Replace( Get_Personal_Views, "$USER_ID$", NNuser_id)
End Function
Sub Remove_View_Settings ( NNuser_id )
objEH.TryORA ( OraSession )
On Error Resume Next
OraDatabase.ExecuteSQL " DELETE FROM view_settings vis WHERE vis.user_id = "& NNuser_id &" AND vis.view_id IN (SELECT vi.view_id FROM views vi WHERE vi.owner_id = "& NNuser_id &")"
objEH.CatchORA ( OraSession )
End Sub
Sub Insert_View_Settings ( NNuser_id, SSpersonalshow )
If SSpersonalshow <> "" Then
objEH.TryORA ( OraSession )
On Error Resume Next
OraDatabase.ExecuteSQL " INSERT INTO view_settings"&_
" SELECT TO_NUMBER('"& NNuser_id &"') AS user_id, vi.view_id FROM views vi WHERE vi.view_id IN ("& SSpersonalshow &")"
objEH.CatchORA ( OraSession )
End If
End Sub
%>
<%
'--- Process submition ---
If (QStrPar("action") <> "") Then
' All mandatory parameters FOUND
Call Remove_View_Settings ( objAccessControl.UserId )
Call Insert_View_Settings ( objAccessControl.UserId, Request("FRpersonalshow") )
End If
%>
Release Manager
