PromptOnRefresh Command

[szeiss]

I have the following code to run a CR 8.0 report.

<!--- Javascript to execute the availability list report --->
<!--
var parReportForm = &quot;&quot;
function displayAvailListReport(rn,USER_NAME)
{
//alert(AVAIL_LIST_REV_NO);
var parRepForm = document.parReportForm;
var reportCall = &quot;&quot;;
var reportCall = reportCall +
//rn + &quot;?password0=cipreport&user0=cipreport&init=actx&prompt0=&quot; +

rn + &quot;?user0=cipreport&password0=cipreport&prompt0=&quot; +
// parRepForm.dept.options[parRepForm.dept.options.selectedIndex].value +
<CFOUTPUT>USER_NAME</CFOUTPUT> +
&quot;&promptOnRefresh#=0&quot;;
reportWindow=window.open(reportCall, &quot;subWindow&quot;, &quot;scrollbars=yes, resizable=yes&quot;
// window.location = reportCall;
// alert(reportCall)
};
//-->

If I refresh the report it asks for the USER_NAME again. How can I keep it from asking again when a user refreshes the report.

Thanks,
Sherry

 

[Silvano]

try passing the url token with the query string:

...options.selectedIndex].value +
<CFOUTPUT>USER_NAME</CFOUTPUT> +
&quot;&promptOnRefresh#=0&<CFOUTPUT>#client.URLToken#</CFOUTPUT>&quot;;


also, is the user_name a cf variable? if so, you are missing # sign - #user_name#,

and, you have a # right after 'promptOnRefresh'? a typo?
Sylvano
dsylvano@hotmail.com

 

[szeiss]

Thanks I took out the # and it's working without prompting for parameters. We had some consultants program the app for us and I believe the # is going to be everywhere after the promptonrefresh. So I guess I have some searching to do.

Thanks,
Sherry