I should have known not to copy and past raw HTML.
I'll try that again - but this time I changed the < to [ and > to ].
[!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd"]
[HTML][HEAD]
[META id=RLT_STANDARDS_MODE_META content=IE=9 http-equiv=X-UA-Compatible]
[META name=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type]
[META name=Generation content="Created in release 8005, Generation 3"]
[SCRIPT type=text/javascript]//confidential_id=IBI_OptionsScript
var szHtmlAlias="/ibi_apps/ibi_html";var szRunTimeHtmlAlias="runTimeHtmlAlias";var cgipath="cgipath";var ibirls="ibirls3";var rltdyncalendar="rltdyncalendar";var map="ibimap";var olap="olap";var olappanebase="olappanebase";var olapdrill="olapdrill";var ibiOptions = new Array(cgipath,ibirls);var nlsScript="/javaassist/nls.js";var nlsVarsScript="/javaassist/nlsvars.js";var glbScript="/javaassist/ibi/html/js/ibigbl.js";var replacePart="[replace]";
var scriptTemplate='[SCRIPT src="'+replacePart+'" type="text/javascript"][\/SCRIPT]';if(typeof(szRunTimeHtmlAlias) === 'string' && szRunTimeHtmlAlias.indexOf('/') == 0)szHtmlAlias=szRunTimeHtmlAlias;document.write(scriptTemplate.replace(replacePart, szHtmlAlias + nlsScript));document.write(scriptTemplate.replace(replacePart, szHtmlAlias + nlsVarsScript));document.write(scriptTemplate.replace(replacePart, szHtmlAlias + glbScript));[/SCRIPT]
[SCRIPT type=text/javascript]//confidential_id=IBI_ibigblloadCss
if(typeof ibigblloadCss === 'function'){ibigblloadCss(null);addIntlTranslatedJS("composertrans.js");}else {alert("JavaScript alias '/ibi_apps/ibi_html' is not valid");window.location("about:blank");}[/SCRIPT]
[TITLE]HtmlPage[/TITLE][LINK id=ITEM2 rel=stylesheet type=text/css UserSuppliedFullPath="1" rtFileName="cgipathsub/ibi_html/javaassist/ibi/html/composer/themes/nonBindows/IBI-Themes/default_theme.css"][LINK id=IBI_THEME_CSS rel=stylesheet type=text/css UserSuppliedFullPath="1" desc="Information Builders" rtFileName="cgipathsub/ibi_html/javaassist/ibi/html/composer/themes/nonBindows/IBI-Themes/ibi.css"]
[SCRIPT for=window type=text/javascript eventname="onload"]window.onload = function() { window_onload(); }[/SCRIPT]
[SCRIPT]//confidential_id=clientEventHandlersJS
//Begin function window_onload
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
[/SCRIPT]
[/HEAD]
[BODY style="OVERFLOW: auto" class=IBI_PageBg edaconnectionrequired="true" elementtype="21" thumbnailscale="4" maptype="0" nextelementuniquenumber="3"][IFRAME style="Z-INDEX: 1; POSITION: absolute; WIDTH: 1270px; HEIGHT: 540px; TOP: 130px; LEFT: 10px" id=report1 class="IBIfield IBI_Report-iFrame IBI_rounded_m" tabIndex=1 elementtype="2" requests_list="0" autoExecute="false" name="report1"][/IFRAME]
[FORM style="Z-INDEX: 2; POSITION: absolute; WIDTH: 477px; HEIGHT: 82px; TOP: 20px; LEFT: 10px" id=form1 class="IBIfield IBI_ReportControlPanel IBI_rounded_m" onsubmit="OnExecute(this);return false;" method=post requests_list="0" form_dist_between_desc_and_input="10" form_hor_dist_between_controls="10" vert_dist_between_controls="10" form_number_of_columns="4" form_number_of_visible_rows="4" form_prompt_location="1" form_type="1" default_slider_type="4" form_newline_chain="1" fexlist_list="report1" tempwidth="477" tempheight="82" name="form1"][LABEL style="Z-INDEX: 5; POSITION: absolute; WIDTH: 54px; DISPLAY: none; HEIGHT: 13px; TOP: 5px; CURSOR: default; LEFT: 5px" id=label1 class="IBIfield IBI_ReportControlLabel" tabIndex=4 for=edit1 name="edit1"]H2O_TITLE[/LABEL][INPUT style="Z-INDEX: 6; POSITION: absolute; OVERFLOW-Y: visible; WIDTH: 140px; DISPLAY: none; OVERFLOW: visible; TOP: 28px; LEFT: 5px" id=edit1 class="IBIfield IBI_ReportControlTarget IBI_rounded_s IBI_TextBox" tabIndex=5 value=" " hspace=0 type=text persistentuniqueid="compUid_1" requiredfield="1" boundtovariable="1" defaultlocation="0,0,15,120" defaultselection="1" name="edit1"][LABEL style="Z-INDEX: 7; POSITION: absolute; WIDTH: 81px; DISPLAY: none; HEIGHT: 13px; TOP: 5px; CURSOR: default; LEFT: 155px" id=label2 class="IBIfield IBI_ReportControlLabel" tabIndex=6 for=edit2 name="edit2"]H2O_CATEGORY[/LABEL][INPUT style="Z-INDEX: 8; POSITION: absolute; OVERFLOW-Y: visible; WIDTH: 140px; DISPLAY: none; OVERFLOW: visible; TOP: 28px; LEFT: 155px" id=edit2 class="IBIfield IBI_ReportControlTarget IBI_rounded_s IBI_TextBox" tabIndex=7 value=" " hspace=0 type=text persistentuniqueid="compUid_2" requiredfield="1" boundtovariable="1" defaultlocation="0,0,15,120" defaultselection="1" name="edit2"][LABEL style="Z-INDEX: 9; POSITION: absolute; WIDTH: 65px; HEIGHT: 13px; TOP: 5px; CURSOR: default; LEFT: 305px" id=label3 class="IBIfield IBI_ReportControlLabel" tabIndex=8 for=edit3 name="edit3"]H2O_RATING[/LABEL][INPUT style="Z-INDEX: 10; POSITION: absolute; OVERFLOW-Y: visible; WIDTH: 140px; OVERFLOW: visible; TOP: 28px; LEFT: 305px" id=edit3 class="IBIfield IBI_ReportControlTarget IBI_rounded_s IBI_TextBox" tabIndex=9 value=" " hspace=0 type=text persistentuniqueid="compUid_3" requiredfield="1" boundtovariable="1" defaultlocation="0,0,15,120" name="edit3"][INPUT style="Z-INDEX: 3; POSITION: absolute; WIDTH: 38px; HEIGHT: 22px; TOP: 55px; LEFT: 5px" id=form1Submit class="IBIfield IBI_button IBI_btn-run" tabIndex=2 value=" " type=submit name="submit1"][INPUT style="Z-INDEX: 4; POSITION: absolute; WIDTH: 38px; HEIGHT: 22px; TOP: 55px; LEFT: 48px" id=form1Reset class="IBIfield IBI_button IBI_btn-reset" tabIndex=3 value=" " type=reset name="reset1"][/FORM][INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden resourcectrlids="ITEM2;IBI_THEME_CSS" name="inputhidden1"][INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=H2OSales type=hidden ismre="1" name="ibiapp_app"][INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibif_ex value=/WFC/Repository/H2OSales/Customer_Sales/WhereTestMovieRating.htm type=hidden name="ibif_ex"][xml id=focus_xmlelement][script type="text/xml" nextelementuniquenumber="3"][rootxmlnode focoption="_FOC_NULL"][variables][variable controltype="7" parametercreatedinreslay="0" type="default" desc="H2O_TITLE" name="H2O_TITLE" default=" " textvarname="" accept="0" select="0" create="1"][link linktype="default" from="compUid_1"][condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" displayfield="H2O_TITLE" datafield="H2O_TITLE" datasource="movies.mas" ibif_ex="movies" selectedvalue=" " operation="" slider_range_from="" slider_range_to="" previewvalue=" " sourcetype="typeMaster"][static_values][static value=" " display=" " selected="1" noinput="0"][/static][/static_values][/data_info][/condition][/link][requestid id="0"][/requestid][/variable][variab
le controltype="7" parametercreatedinreslay="0" type="default" desc="H2O_CATEGORY" name="H2O_CATEGORY" default=" " 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 datatype="0" modifiedrequest="0" displayfield="H2O_CATEGORY" datafield="H2O_CATEGORY" datasource="movies.mas" ibif_ex="movies" selectedvalue=" " operation="" slider_range_from="" slider_range_to="" previewvalue=" " sourcetype="typeMaster"][static_values][static value=" " display=" " selected="1" noinput="0"][/static][/static_values][/data_info][/condition][/link][requestid id="0"][/requestid][/variable][variable controltype="7" parametercreatedinreslay="0" type="default" desc="H2O_RATING" name="H2O_RATING" default=" " textvarname="" accept="0" select="0" create="1"][link linktype="default" from="compUid_3"][condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" displayfield="H2O_RATING" datafield="H2O_RATING" datasource="movies.mas" ibif_ex="movies" selectedvalue=" " operation="" slider_range_from="" slider_range_to="" previewvalue=" " sourcetype="typeMaster"][static_values][static value=" " display=" " selected="1" noinput="0"][/static][/static_values][/data_info][/condition][/link][requestid id="0"][/requestid][/variable][/variables][input_controls][input_control bindcontrolid="compUid_1" elementtype="7" name="edit1" id="edit1" multiple="0" onetimepopulated="1"][link linktype="default" persistentuniqueid="compUid_1"][condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" datasource="movies.mas" ibif_ex="movies" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE"][static_values][static value=" " display="" selected="0" noinput="0"][/static][/static_values][/data_info][/condition][/link][/input_control][input_control bindcontrolid="compUid_2" elementtype="7" name="edit2" id="edit2" multiple="0" onetimepopulated="1"][link linktype="default" persistentuniqueid="compUid_2"][condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" datasource="movies.mas" ibif_ex="movies" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE"][static_values][static value=" " display="" selected="0" noinput="0"][/static][/static_values][/data_info][/condition][/link][/input_control][input_control bindcontrolid="compUid_3" elementtype="7" name="edit3" id="edit3" multiple="0" onetimepopulated="1"][link linktype="default"][condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" datasource="movies.mas" ibif_ex="movies" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE"][static_values][static value=" " display="" selected="0" noinput="0"][/static][/static_values][/data_info][/condition][/link][/input_control][/input_controls][requests nextrequestsid="0"][request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0" compoundreport="0" reportcolumns="" reportrealcolumns="" ibiapp_app=""][![CDATA[-* Set up blank deafults
-DEFAULT &H2O_TITLE = '';
-DEFAULT &H2O_CATEGORY = '';
-DEFAULT &H2O_RATING = '';
-* If Blank - change to _FOC_NULL - webFOCUS param that will drop out the whole line if _FOC_NULL exists (secrelty this means the where clause goes BYE-BYE
-SET &H2O_TITLE = IF TRUNCATE(&H2O_TITLE) EQ '' THEN '_FOC_NULL' ELSE &H2O_TITLE ;
-SET &H2O_CATEGORY = IF TRUNCATE(&H2O_CATEGORY) EQ '' THEN '_FOC_NULL' ELSE &H2O_CATEGORY;
-SET &H2O_RATING = IF TRUNCATE(&H2O_RATING) EQ '' THEN '_FOC_NULL' ELSE &H2O_RATING;
-* Massage user input. If Blank - do nothing to speed processing. If Not Blank - Left Justify, Upper Case, Trim trailing blanks and add the % for the LIKE SQL statement.
-IF &H2O_TITLE EQ '_FOC_NULL' THEN GOTO :ENDTITLE ELSE CONTINUE;
-SET &H2O_TITLE = LJUST(&H2O_TITLE.LENGTH,&H2O_TITLE,'A&H2O_TITLE.LENGTH');
-SET &H2O_TITLE = UPCASE(&H2O_TITLE.LENGTH,&H2O_TITLE,'A&H2O_TITLE.LENGTH');
-SET &H2O_TITLE = TRUNCATE(&H2O_TITLE);
-SET &H2O_TITLE = '%' || &H2O_TITLE || '%';
-:ENDTITLE;
-* Massage user input. If Blank - do nothing to speed processing. If Not Blank - Left Justify, Upper Case, Trim trailing blanks and add the % for the LIKE SQL statement.
-IF &H2O_CATEGORY EQ '_FOC_NULL' THEN GOTO :ENDCATEG ELSE CONTINUE;
-SET &H2O_CATEGORY = LJUST(&H2O_CATEGORY.LENGTH,&H2O_CATEGORY,'A&H2O_CATEGORY.LENGTH');
-SET &H2O_CATEGORY = UPCASE(&H2O_CATEGORY.LENGTH,&H2O_CATEGORY,'A&H2O_CATEGORY.LENGTH');
-SET &H2O_CATEGORY = TRUNCATE(&H2O_CATEGORY);
-SET &H2O_CATEGORY = '%' || &H2O_CATEGORY || '%';
-:ENDCATEG;
-* Massage user input. If Blank - do nothing to speed processing. If Not Blank - Left Justify, Upper Case, Trim trailing blanks and add the % for the LIKE SQL statement.
-IF &H2O_RATING EQ '_FOC_NULL' THEN GOTO :ENDRATING ELSE CONTINUE;
-SET &H2O_RATING = LJUST(&H2O_RATING.LENGTH,&H2O_RATING,'A&H2O_RATING.LENGTH');
-SET &H2O_RATING = UPCASE(&H2O_RATING.LENGTH,&H2O_RATING,'A&H2O_RATING.LENGTH');
-SET &H2O_RATING = TRUNCATE(&H2O_RATING);
-:ENDRATING;
TABLE FILE MOVIES
PRINT
MOVIES.MOVINFO.TITLE
MOVIES.MOVINFO.CATEGORY
MOVIES.MOVINFO.RATING
MOVIES.MOVINFO.DIRECTOR
WHERE MOVIES.MOVINFO.TITLE LIKE &H2O_TITLE.QUOTEDSTRING;
WHERE MOVIES.MOVINFO.CATEGORY LIKE &H2O_CATEGORY.QUOTEDSTRING;
WHERE MOVIES.MOVINFO.RATING EQ &H2O_RATING.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END]]][/request][/requests][other_bound_objects][/other_bound_objects][/rootxmlnode][/script]
[/xml][/BODY]
[SCRIPT type=text/javascript]//confidential_id=IBI_loader
if(typeof doBeforeLoad === 'function'){doBeforeLoad();}function AdjustChildrenPosition(){
}
[/SCRIPT]
[/HTML]
[!-- cc frynk --]
webFOCUS 8207.15
WindowsServer 2019