Hello everybody, it's been a long time since I posted/read this forum. But here we are again.
First off, we're still working with version 5.2.4 of WebFocus. (I know :s)
It's about the following. I have a <select name="CUR"><option value="USD">...</select> element in my webpage. This has been placed in a form-element with the action attribute set to the cgi-thingie. Because of it being a published report, inside the form element, there also is a hidden input field called IBIMR_fex, which points to the fex I'm executing on submitting the form. So when I select multiple options, I should be able to access this array of values by having the following code in my fex: -IF &CUR0.EXISTS THEN GOTO CAY ELSE GOTO CAN; -CAY; -SET &CurArray = ''''; -REPEAT CurLewp FOR &I FROM 1 TO &CUR0; -SET &CurArray = IF &I EQ 1 THEN &CurArray || &CUR.&I -ELSE &CurArray || ''',''' || &CUR.&I; -CurLewp -SET &CurArray = &CurArray || ''''; WHERE V_PRICE_REBATE.PRICECUR IN (&CurArray); -CAN; ...
This would eventually produce a statement like this: WHERE ... IN ('USD','EUR','GBP'); (where the currencies were the selected ones in the html form). Instead, on submitting the form, I'm getting a prompt for CUR0.
I have tried using the WFServlet instead of cgi, but then webfocus also prompts me for I
The strangest part is we already have a likewise report (also taking multiple selected values and doing stuff with them in the fex) running on the same webserver with the same version. This _is_ using the WFServlet however. But the code is the same.
Any ideas are welcome.
Edit: typo.This message has been edited. Last edited by: Tim Schraepen,
WebFocus 5.2.4 iWay ETL Manager 5.2.4 Windows 2000
May 19, 2006, 03:49 AM
Tim Schraepen
Update: I think this issue has something to do with the fex that I'm trying to execute being an MRE report. The other report that _is_ working is not an MRE fex and is placed in our wfs/apps directory.
Update: I can confirm the behaviour I mentioned above. Is this working as intended or is there perhaps some sort of workaround so it also works with MRE (published) reports?
Edit: sorry for the new post instead of an edit of my previous post.This message has been edited. Last edited by: Tim Schraepen,
WebFocus 5.2.4 iWay ETL Manager 5.2.4 Windows 2000
May 19, 2006, 12:36 PM
Francis Mariani
Turning off the "Prompt for parameters" option for the MRE report may resolve the issue.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server