I need to understand how to program a button to set a session variable and then check/read that variable to either skip or run a sql statement on the List page:Before sQL query event.
my "show all" button is located on the project_list.asp.
Client before code...
params["txt"] = "Hello";
ctrl.setMessage("Requesting to show all Projects...");
Server code...
set Session("showall")="on"
result("txt") = "Showing all Projects"
Client After code...
ar message = result["txt"] + " !!!";
ctrl.setMessage(message);
location.href="Projects_list.asp"
i have the following code on the List page:Before process....
Response.Write Session("showall")
i have the following code on the List page:Before SQL query....
dim flag
if session("showall")<>"on" then
if SESSION("userid")="US\rgrahamj" or SESSION("userid")="US\raparker" or SESSION("userid")="US\jmack025" then
flag=1
strSQL = "SELECT FROM dbo.Projects WHERE (status = 'Open' OR status = 'On-Hold') ORDER BY assigneeUID,priority"
end if
if flag<>"1" then
if SESSION("userid")="US\hposton" then
strSQL = "SELECT FROM dbo.Projects WHERE assigneeUID = 'hposton' AND (status = 'Open' OR status = 'On-Hold') ORDER BY priority"
end if
if SESSION("userid")="US\drolan" then
strSQL = "SELECT FROM dbo.Projects WHERE assigneeUID = 'drolan' AND (status = 'Open' OR status = 'On-Hold') ORDER BY priority"
end if
if SESSION("userid")="US\tmoore07" then
strSQL = "SELECT FROM dbo.Projects WHERE assigneeUID = 'tmoore07' AND (status = 'Open' OR status = 'On-Hold') ORDER BY priority"
end if
if SESSION("userid")="US\twilli24" then
strSQL = "SELECT FROM dbo.Projects WHERE assigneeUID = 'twilli24' AND (status = 'Open' OR status = 'On-Hold') ORDER BY priority"
end if
if SESSION("userid")="US\dbarino" then
strSQL = "SELECT FROM dbo.Projects WHERE assigneeUID = 'dbarino' AND (status = 'Open' OR status = 'On-Hold') ORDER BY priority"
end if
end if
end if
