[CLOSED] HTML Composer using WebFOCUS 8

I'm creating an HTML with a static radio button allowing the user to choose two options. The options are actually the order of operation to select on. Example, show me all records having GE 50 days with expired product. The two operations are GE and LE. In my fex, my parameter works correctly passing LE or GE. Though, when I try to pass the parameter from the radio button, it put's single quotes around the order of operation. This is of course causing my where statement to fail. Any ideas on where within the HTML composer...I'm getting the single quotes passed in my operation parameter?

Thanks,
Rita Combs
Dollar General Corp.

This message has been edited. Last edited by: <Kathryn Henning>,

WebFOCUS 8: Nov 2014. Platform/OS: Linux. WebFOCUS Developers Studio Version 8008.
Data Sources: Oracle. Output Formats: PDF, HTML, AHTML, EXL2k, WF8 Portals.

Posts: 3 | Registered: May 24, 2012

MartinY

Virtuoso

posted

Hide Post

Hi Rita,

Please update your signature with WF version.

As far as I know there is no option to add or remove quote for radio, it shouldn't have any indeed. Don't know why you have some without seeing your code.

Below code written with HTML Composer that call a little fex using variables.

HTML:

<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7703, Generation 3.0">
<TITLE>HtmlPage</TITLE>
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>

<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";

var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";

var ibixmltree="ibixmltree";

var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>

<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>

<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>

<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>

<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>

<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
 
UpdateData();
 
}

function button1_onclick(ctrl) {
OnExecute(ctrl)
}
</SCRIPT>

<SCRIPT for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>

<META name=GENERATOR content="MSHTML 11.00.9600.17420"></HEAD>
<BODY style="OVERFLOW: auto" nextelementuniquenumber="12" thumbnailscale="4" elementtype="21" edaconnectionrequired="true">
<SELECT spellcheck=false tabIndex=1 id=edit1 style="WIDTH: 120px; POSITION: absolute; LEFT: 50px; TOP: 50px" size=1 vspace="0" indeterminate="false" width="0" CHECKED="false" loop="1" maxLength="2147483647" hspace="0" readOnly="false" start="fileopen" rawvalue="E" defaultselection="1" persistentuniqueid="compUid_1" name="edit1"></SELECT> 
<INPUT onclick=button1_onclick(this) tabIndex=2 id=button1 language=javascript style="HEIGHT: 25px; WIDTH: 165px; POSITION: absolute; LEFT: 50px; Z-INDEX: 1; TOP: 180px" type=button value=Button autoExecute="false" requests_list="1" name="button1"> 
<SPAN tabIndex=3 id=radio1 contentEditable=false style="HEIGHT: 60px; WIDTH: 100px; POSITION: absolute; LEFT: 50px; Z-INDEX: 2; TOP: 100px" elementtype="12" defaultselection="1" persistentuniqueid="compUid_2" groupChildren="1" columns="1" name="radio1">
<TABLE contentEditable=false style="HEIGHT: 100%; WIDTH: 100%" cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD noWrap>
<LABEL id=radio1_LABEL_0 style="CURSOR: default" for=radio1_0>
<INPUT tabIndex=3 id=radio1_0 type=radio value=LT noinput="0" displaytext="LT" name="radio1">LT</LABEL></TD></TR>
<TR>
<TD noWrap>
<LABEL id=radio1_LABEL_1 style="CURSOR: default" for=radio1_1>
<INPUT tabIndex=3 id=radio1_1 CHECKED type=radio value=EQ noinput="0" displaytext="EQ" name="radio1">EQ</LABEL></TD></TR>
<TR>
<TD noWrap>
<LABEL id=radio1_LABEL_2 style="CURSOR: default" for=radio1_2>
<INPUT tabIndex=3 id=radio1_2 type=radio value=GT noinput="0" displaytext="GT" name="radio1">GT</LABEL></TD></TR></TBODY></TABLE></SPAN>
<INPUT id=layoutinfo style="POSITION: absolute; LEFT: -100px; TOP: -100px" type=hidden persistentuniqueid="compUid_8"> 
<INPUT id=ibiapp_app style="POSITION: absolute; LEFT: -100px; TOP: -100px" type=hidden value=baseapp persistentuniqueid="compUid_9" ismre="1" name="ibiapp_app"> 
<INPUT id=ibif_ex style="POSITION: absolute; LEFT: -100px; TOP: -100px" type=hidden value=app/htmlsamp.htm persistentuniqueid="compUid_10" name="ibif_ex"> 
<INPUT id=IBIMR_domain style="POSITION: absolute; LEFT: -100px; TOP: -100px" type=hidden value=untitled/untitled.htm persistentuniqueid="compUid_11" name="IBIMR_domain"> 
<INPUT id=IBIMR_folder style="POSITION: absolute; LEFT: -100px; TOP: -100px" type=hidden value=#reportzp9oet persistentuniqueid="compUid_12" name="IBIMR_folder"> 
<xml id=focus_xmlelement>
<script type="text/xml" nextelementuniquenumber="4">
	
<rootxmlnode focoption="_FOC_NULL">
		
<variables>
			
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="CNT" name="CNT" default="ITALY" textvarname="" accept="0" select="0" create="1">
				
<link linktype="default" from="compUid_1" persistentuniqueid="compUid_2">
					
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info checkForDuplicateValues="0" displayfield="CNT" datafield="CNT" datasource="car.mas" datatype="0" selectedvalue="ITALY" operation="" slider_range_from="" slider_range_to="" previewvalue="ITALY" sourcetype="typeMaster" linktype="none">
							
<static_values>
								
<static value="ITALY" display="ITALY" selected="1" noinput="0"></static></static_values></data_info></condition></link>
				
<requestid id="1"></requestid></variable>
			
<variable controltype="7" parametercreatedinreslay="0" type="default" desc="RADIO" name="RADIO" default="GE" textvarname="" accept="0" select="0" create="1">
				
<link linktype="default" from="compUid_2">
					
<condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info checkForDuplicateValues="0" displayfield="RADIO" datafield="RADIO" datasource="car.mas" datatype="0" selectedvalue="GE" operation="" slider_range_from="" slider_range_to="" previewvalue="GE" sourcetype="typeMaster">
							
<static_values>
								
<static value="GE" display="GE" selected="1" noinput="0"></static></static_values></data_info></condition></link>
				
<requestid id="1"></requestid></variable></variables>
		
<input_controls>
			
<input_control bindcontrolid="compUid_1" elementtype="8" name="edit1" id="edit1" multiple="0" onetimepopulated="0" inbinding="1" textvarname="CNT_TEXT">
				
<link linktype="default" persistentuniqueid="compUid_1">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info checkForDuplicateValues="0" accept="0" sourcetype="typeMaster" datatype="1" modifiedrequest="1" datafield="CNTRY" displayfield="COUNTRY" selectedvalue="X" addalloption="0" operation="NONE">
							
<![CDATA[DEFINE FILE CAR
CNTRY /A1 = DECODE COUNTRY ('FRANCE' 'F' 'JAPAN' 'J' 'ENGLAND' 'E' 'ITALY' 'I' ELSE 'G');
END
TABLE FILE CAR
PRINT COUNTRY
BY CNTRY
ON TABLE PCHOLD FORMAT XML
END]]></data_info></condition></link></input_control>
			
<input_control bindcontrolid="compUid_2" elementtype="12" name="radio1" id="radio1" multiple="0" onetimepopulated="1">
				
<link linktype="default" persistentuniqueid="compUid_3">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info checkForDuplicateValues="0" sourcetype="typeMaster" modifiedrequest="0" datasource="" displayfield="" datafield="" datatype="0" selectedvalue="GE" accept="0" addalloption="0" operation="NONE">
							
<![CDATA[]]>
							
<static_values>
								
<static value="LT" display="LT" selected="0" noinput="0"></static>
								
<static value="EQ" display="EQ" selected="1" noinput="0"></static>
								
<static value="GT" display="GT" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control>
			
<input_control bindcontrolid="compUid_8" elementtype="26" name="layoutinfo" id="layoutinfo" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" accept="0">
<static_values>
<static value="" display="" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_9" elementtype="26" name="ibiapp_app" id="ibiapp_app" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" accept="0">
<static_values>
<static value="baseapp" display="" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_10" elementtype="26" name="ibif_ex" id="ibif_ex" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" accept="0">
<static_values>
<static value="app/htmlsamp.htm" display="" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_11" elementtype="26" name="IBIMR_domain" id="IBIMR_domain" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" accept="0">
<static_values>
<static value="untitled/untitled.htm" display="" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_12" elementtype="26" name="IBIMR_folder" id="IBIMR_folder" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info checkForDuplicateValues="0" accept="0">
<static_values>
<static value="#reportzp9oet" display="" selected="0" noinput="0"></static></static_values></data_info></condition></link></input_control></input_controls>
		
<other_bound_objects></other_bound_objects>
		
<requests nextrequestsid="1">
			
<request requestid="1" sourcetype="typeFex" targettype="window" targetname="_blank" ibif_ex="app/zzzzzzz.fex" IBIMR_domain="untitled/untitled.htm" IBIMR_folder="#reportzp9oet" IBIMR_sub_action="MR_STD_REPORT" activereport="0" reportcolumns="" reportrealcolumns="" ibiapp_app="baseapp"></request></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>

Fex:

-DEFAULT &CNT = 'ITALY'
-DEFAULT &RADIO = 'GE'
-TYPE cnt: &CNT, radio: &RADIO
-*-EXIT

DEFINE FILE CAR
CNTRY /A1 = DECODE COUNTRY ('FRANCE' 'F' 'JAPAN' 'J' 'ENGLAND' 'E' 'ITALY' 'I' ELSE 'G');
END
TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
WHERE CNTRY &RADIO '&CNT';
END

WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007

Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013

Ignored post by MartinY posted

Show Post

George Patton

Master

posted

Hide Post

All you have to do is create an Amper variable that contains the GE or LE statement and use that variable is the basis for the radio button.

eg

-SET &GE_LE=IF &CHOICE EQ 1 THEN 'WHERE A GE B' ELSE 'WHERE A LE B';

TABLE FILE XYZ
...
...
&GE_LE
...
END

(You may need quotes around the 1 - or whatever other value you use in the radio button control)

Note that if you put an amper variable like &GE_LE in yout table request the Dev Studio GUI will complain. So just insert a standard WHERE clause while you are setting up and styling the FEX and then substitute the &GE_LE afterwards. Works perfectly.

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP

Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010

Ignored post by George Patton posted

Show Post

Rita Combs

Member

posted

Hide Post

Here's what I have in my fex

...
-DEFAULT &OPER = '' ;
...
TABLE FILE ...
WHERE FIELD &OPER.EVAL &VALUE ;
...

Here's what is in the fex at run time when &OPER is selected as EQ and &VALUE is selected as 50:

TABLE FILE ...
WHERE FILED 'EQ' 50 ;
...

Note the EQ is quoted and it shouldn't be.

Thanks, Rita

WebFOCUS 8: Nov 2014. Platform/OS: Linux. WebFOCUS Developers Studio Version 8008.
Data Sources: Oracle. Output Formats: PDF, HTML, AHTML, EXL2k, WF8 Portals.

Posts: 3 | Registered: May 24, 2012

Ignored post by Rita Combs posted

Show Post

Tom Flynn

Expert

posted

Hide Post

1. Open in HTML Composer
2. Click on the &OPER selection area
3. Change Add QUOTES on the right in Properties to No

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

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

Ignored post by Tom Flynn posted

Show Post

Doug

Expert

posted

Hide Post

Thanks Tom, We don't see "Add QUOTES on the right in Properties" any place (properties for the raio button or the amper variable). Could you send a picture / image of what you're seeing? Maybe we're missing what the "the &OPER selection area" is?
~ Doug

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

Tom Flynn

Expert

posted

Hide Post

Hi Doug,
Didn't know this was your group! Even though it says Multiple: Add Quotes, and, it's not Multiple, set it to No anyway...
Tom

PS. If this doesn't work, strip them out:

  
-SET &OPERX = IF &OPER CONTAINS '''' THEN STRREP(&OPER.LENGTH, &OPER, 1, '''', 0, 'X', &OPER.LENGTH, 'A&OPER.LENGTH')  ELSE &OPER;

Then: WHERE FIELD &OPERX.EVAL &VALUE ;

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

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

Ignored post by Tom Flynn posted

Show Post

MattC

Guru

posted

Hide Post

Tom - That's not an option for a radio control.

WebFOCUS 8.1.05

Posts: 496 | Registered: January 04, 2008

Ignored post by MattC posted

Show Post

Rita Combs

Member

posted

Hide Post

I'm not having luck seeing it...so must not be an option like MattC says. We thought about stripping it out...I personally just was trying to understand all the options hoping there was one I could not see.
Thank you all for trying to help. Guess I'll just strip it.

Rita

WebFOCUS 8: Nov 2014. Platform/OS: Linux. WebFOCUS Developers Studio Version 8008.
Data Sources: Oracle. Output Formats: PDF, HTML, AHTML, EXL2k, WF8 Portals.

Posts: 3 | Registered: May 24, 2012

Ignored post by Rita Combs posted

Show Post

Tom Flynn

Expert

posted

Hide Post

AHH, OK., Thanks Matt.

We have plenty of Radio buttons and have never had them come through with quotes around the selection, AND, they shouldn't unless you have them quoted in the Value. Or, there is other code putting quotes on...

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

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

Ignored post by Tom Flynn posted

Show Post

Doug

Expert

posted

Hide Post

quote:
Didn't know this was your group!

Yeah Tom, I'm just part of one of the Dollar General WebFOCUS Groups around here. Helping out where I can. This one even stumped me... I think that we'll do the STRIP as a work-around and get with IB, maybe even a case. I'll leave that final call up to Rita

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[CLOSED] HTML Composer using WebFOCUS 8

Focal Point | Privacy Statement | Terms of Service