<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'| |
'| MEMBERS |
'| INDEX |
'=====================================================
%>
<%
Option explicit
' Good idea to set when using redirect
Response.Expires = 0 ' always load the page, dont store
%>
<%'Refresh parent window after the child window is closed
'If QStrPar("refresh") = "true" Then
' Call Destroy_All_Objects
' Response.Redirect( scriptName &"?done=done"& QSTR) ' Note: "done" parameter is required as QSTR cannot stant on its own.
'End If
%>
<%
'------------ 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 )
OraSession.BeginTrans
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 &")"
OraSession.CommitTrans
End Sub
Sub Insert_View_Settings ( NNuser_id, SSpersonalshow )
If SSpersonalshow <> "" Then
OraSession.BeginTrans
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 &")"
OraSession.CommitTrans
End If
End Sub
%>
<%
'--- Process submition ---
'If (QStrPar("action") <> "") Then
' All mendatory parameters FOUND
' Call Remove_View_Settings ( objAccessControl.UserId )
' Call Insert_View_Settings ( objAccessControl.UserId, Request("FRpersonalshow") )
'End If
%>
Deployment Manager
Exit
