HTML Form - passing values without tick marks?

I created an HTML form for a .fex that takes in many parameters a while back and it worked for quite some time.

Now, we're recieving an error of
0 ERROR AT OR NEAR LINE 304 IN PROCEDURE wcqrgj18FOCEXEC *
(FOC257) MISSING QUOTE MARKS: ''01'';
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

when we run that .fex from the html form.
The line in the .fex is
WHERE FACILITY_CODE EQ '&FACILITY_CODE.(OR(FIND FACL IN ACPBANKL)).FACILITY_TEST.';

We changed the line to enclose the &FACILITY_CODE in single ticks because we're passing values from graphs into it and couldn't get it to run any other way.
Is there a way to make the HTML form not pass the value enclosed in tick marks now that we're adding ticks to it in the .fex?

Thanks

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

Tom Flynn

Expert

posted

Hide Post

Jason,

If you created a HTML form populating a list box with the FACILITY values, and, allowing the user to select MULTIPLE values, with FOC_NONE being the default, then your code S/B changed to:

WHERE FACILITY_CODE EQ &FACILITY_CODE;

If you are actually using the AUTOPROMPTER, as this indicates, you need to convert the blanks and quotes to values you can pass to the next FEX:

-* Translate Special Characters in PARMS so Multiple Drilldown(s) Work
-*
-* CHANGE BLANK(32) TO UNDERSCORE(95)
-* CHANGE QUOTE(39) TO ASTERISK(42)
-* CHANGE AMPER(38) TO EXCLAMATION(33)
-*
-* Convert Parms for &Organization
-*
-SET &LEN=&Organization.LENGTH ;
-SET &FMT='A' | &LEN.EVAL ;
-SET &C_ORG1= CTRAN(&LEN, &Organization, 32, 95,'&FMT');
-SET &C_ORG2= CTRAN(&LEN, &C_ORG1, 39, 42, '&FMT');
-SET &C_ORG3= CTRAN(&LEN, &C_ORG2, 38, 33, '&FMT');
-SET &CONVERT_ORG=IF &Organization EQ 'FOC_NONE' THEN &Organization ELSE &C_ORG3;
-TYPE Organization = &CONVERT_ORG

Then reverse them in the next FEX.

Did I confuse the issue???

Tom

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Please Wait. Your request is being processed...