Help with Scripting

[rcaesar]

I have a powerprompt application (two drop downs) that kick off a report. The problem is the filter from the prompt values do no seem to pass to the report.

The server side script is here. When run the whole report comes up without this filter.


Question: As I am not using dynamos for this application, do I still need to modify the SCRIPT in the PowerPrompt Editor?

I hope someone can help me out here.
Thanks
___________________

var oRs = oConn.Execute("SELECT DISTINCT Mgr_Full_Nm FROM CATW.VAMNDED_CNTRCT_W INNER JOIN CATW.VDELIVERABLE_W ON CATW.VAMNDED_CNTRCT_W.Cntrct_Id = CATW.VDELIVERABLE_W.Cntrct_Id WHERE (Msrmt_Due_Dt > Current_Date AND Msrmt_Due_Dt <= (Current_Date + 35 DAYS)) AND Sts_Tx in " + first_symbol + needed_character + second_new_status + needed_character + second_symbol, "CATS-POWER-PROMPT");