HTML Form - refresh listbox?

I'm attempting to add a Search for customer textbox in my html form. It allows for partial user input of a customer name, for example "Joe" will return "Joe Smith" and "Joe Jones".

A button on my html form calls a fex that creates a sql out of the resulting information of "joe smith" and "joe jones", but the listbox that is built to show this information isn't being updated. Is there a way to make this information show up in the textbox as the hold file is created?

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

Kerry

Expert

posted

Hide Post

Hi Jason,

You may want to consider Information Builders' professional service for assistance, but before that, it is recommended that you contact Information Builders' Customer Support Services and open a case first.

To open a case, you may either call at 1-800-736-6130, or access the online system InfoResponse. Here is a list of information to be ready when you call: http://techsupport.ibi.com/before_you_call.jsp.

Hope this helps.

Cheers,

Kerry

Kerry Zhan
Focal Point Moderator
Information Builders, Inc.

Posts: 1948 | Location: New York | Registered: November 16, 2004

Ignored post by Kerry posted

Show Post

Darin Lee

Virtuoso

posted

Hide Post

Try redisplaying the HTML form after running your fex with -HTMLFORM formname

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Show Post

Tony A

Expert

posted

Hide Post

Jason,

This is fairly simple to do if you consider that all you want to do is run a fex into a control on your page's form.

Create your control (div or iframe etc.) with a visibility style of hidden and with a src value of a blank page as default. Then add JavaScript to change the src to the results of a fex. You would need to call a function as the result of trapping an event something like "onchange" or "onclick" (probably the latter).

In your JavaScript you would assign the object so that you can access it's properties. Once you have the value then you can reassign the src location of your iframe to run your fex.

Something like this should help you -

    function ShowValues(ctlFilterId) {
       objFilter = document.getElementById(ctlFilterId);
       // Replace special characters by the relevant escape sequence
       temp = objFilter.value; // temporary holder
       temp = escape(temp);
 
       // By changing the location of a particular div to a url that will run a focexec,
       // we can show possible values for selection or checking. (place the next code on one line)
       self.yourIframe.location=
         '/ibi_apps/WFServlet?IBIC_server=EDASERVE&IBIAPP_app=baseapp&IBIF_ex=yourfex&Filter='
          +temp+'&Rand='+Math.random();
       //
       self.yourIframe.style.visibility = "visible";
    }

I am sure that the code would need to be tidied up as it was quickly thrown together and has not been tested, but it should give you the gist.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

Please Wait. Your request is being processed...