[SOLVED] Passing Multi-select results from FEX to stored procedure
Hello all,
I am posting here as a last resort...I have tried every avenue that I know and now I put myself at your mercy.
I have a fex that passes values to a master file based on a stored procedure. I use an if statement in the fex connecting the proc parameter to an amper variable - the following is obviously single select, and works fine..
IF PRC_MULTI_LOCATION_TEST.INPUT.@LOCPARAM EQ &LOCPARAM
The problem occurs when I attempt to use a multiselect OR in this scenario, scripted this way:
IF PRC_MULTI_LOCATION_TEST.INPUT.@LOCPARAM EQ &LOCPARAM.(OR(FIND CODE IN VW_USER_LOCATION_MASTER)).LOCPARAM.
When I run the fex with the above multiselect in place I get the following error:
(FOC1631) MORE THAN ONE IF/WHERE TEST FOR FIELD @LOCPARAM
I need to pass multiple values to the stored procedure. What is the best method of doing this? I have attempted JavaScript on the HTML launch page side, various experiments with DEFINE in the fex...no luck. Has anyone out there experienced this, and if so have you conquered it? Any help with this would be appreciated!This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.11, Windows XP, Server 2003, SQL Server 7/2005 PDF, HTML, Excel
February 23, 2011, 03:12 AM
Ramkumar - Webfous
Hi JRenner,
Could you please clarify the following things ?
stored procedure - Is the WF stored procedure or DB stored procedure..
Multi Select - Are you mentioning about the Multi Select List box which passes you the parameter value from an user input screen ?
Thanks,
Ramkumar. WebFOCUS/Tableau Webfocus 8 / 7.7.02 Unix, Windows HTML/PDF/EXCEL/AHTML/XML/HTML5
Thanks to both of you for your inquiries - sorry it took so long to get back on here, with projects pulling me around...well, you guys know how that is.
@Tom: your solution, coupled with another I found here on the forums, solved my issue. Thanks so much for that. Now all I need to do is get this report (a compound report) outputting properly given the breakout of the multiple locations, I'd be set - I get the first portion of the report to output split by location, but the two other pieces still bundle at the bottom of the page (spreadsheet actually). It'll take some doing, but I will figure it out.
Thanks again!
WebFOCUS 7.6.11, Windows XP, Server 2003, SQL Server 7/2005 PDF, HTML, Excel