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!

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

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

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