Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Dynamically Populate Dropdown list.
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Dynamically Populate Dropdown list.
 Login/Join
 
Silver Member
posted
Hi,

I have two check boxes and a dropdown list.one for US and one for Canada.when somebody checks US, the dropdown should be populated with all the states in US.when somebody checks Canda,the dropdown should be populated with all the provinces in Canada.I have all the states and provinces in a reference table.

I am not able to accomplish this.should I use javascript? I only know populating a dropdown statically or dynamically.Can somebody put some thoughts into this.

Thanks.

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.7
windows
Html,Pdf and Excel
 
Posts: 39 | Registered: September 03, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
HTML Composer implements the concept of "chained controls" but that feature is available, I think, as of WebFOCUS 7.6.9.

I don't know if there's any similar to that for your version of the product though.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Master
posted Hide Post
you can use 2 static drop down list box. One for US and another for Canada. Using style.visibility property, toggle the drop down based on check box selection.
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
Master
posted Hide Post
You can also use AJAX to refresh the dropdown based on checkbox seletion. In this there are 2 methods.
1. For every action on checkbox, you can send a request to webFOCUS and reload the dropdown.
2. During page load itself, you can bring data for both the selection and store it as javascript object (xml file, array, etc). During checkbox selection, query against this array and refresh the dropdown.

I recommend second option, as this will take less time to refresh the dropdown.
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Dynamically Populate Dropdown list.

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.