Your SAS programs, embedded in web apps and elsewhere

Information Delivery Portal 4.2 Prompts User Twice when using Post Back in a Stored Proc

Accepted Solution Solved
Reply
Super Contributor
Posts: 484
Accepted Solution

Information Delivery Portal 4.2 Prompts User Twice when using Post Back in a Stored Proc

I am using SAS Information Delivery Portal 4.2 to display a stored procedure in a SAS Stored Process Portlet.  I included a refresh button to update the stored procedure each time the user changes a dropdown option.  The user experiences an extra login that I would like to remove. 

First the user logs into SAS Information Delivery Portal 4.2 where the user is prompted for credentials.  Then the user clicks on the tab containing the portlet.  The stored procedure shows correctly.  The user changes a dropdown parameter.  The user clicks refresh.  The stored procedure calls a postback method and reloads the page. Only on the first time the page refreshes is the user prompted for credentials, clicking refresh again will not prompt the user. 

The post back call is:

PUT "<FORM METHOD='POST' ACTION='https://server1.com/SASStoredProcess/do'>";

The driver method is

/*driver function for displaying the form*/

%MACRO DisplayForm();

     DATA _null_;

     FILE _WEBOUT;

     PUT "<html>";

     PUT "<body>";

     PUT "<div style='font-family: Verdana; font-size: 8pt;'>";

     PUT "<CENTER>";

     PUT "<FORM METHOD='POST' ACTION='https://server1.com/SASStoredProcess/do'>";

PUT "<input type='hidden' name='_program' value='/Users/User_Name/My Folder/Stored Procedure Name' />";

    

     PUT "<input type='hidden' name='_action' value='EXECUTE' />";

     DATA _null_;

     file _webout;

     PUT "<tr>";

     PUT "<td colspan='2'>";

     PUT "<input type='submit' style='font-family: Verdana; font-size: 8pt;' class='button' value='Refresh' />";

     PUT "</td>";

     PUT "</tr>";

     Run;

     %ProcessReport();

     DATA _null_;

     file _webout;

     PUT "</table>";

     PUT "</FORM>";

     PUT "</CENTER>";

     PUT "</div>";

     PUT "</body>";

     PUT "</html>";

     file _webout;

     RUN;

%MEND DisplayForm;


Accepted Solutions
Solution
‎01-29-2015 02:21 PM
Super Contributor
Posts: 484

Re: Information Delivery Portal 4.2 Prompts User Twice when using Post Back in a Stored Proc

Used a url portlet instead.

View solution in original post


All Replies
Solution
‎01-29-2015 02:21 PM
Super Contributor
Posts: 484

Re: Information Delivery Portal 4.2 Prompts User Twice when using Post Back in a Stored Proc

Used a url portlet instead.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 794 views
  • 0 likes
  • 1 in conversation