Datalist & Select Element Usage

This demo page shows:

how to use Data List tag, populate_datalist function and record set variables
how to fill a drop down list with a Data List tag
how to define a look up select element

Create a new sub folder named selectElement under the site\pages folder of the installation path.

Form File:

Create a file named selectElement.frmx and copy/paste the code block showed below into the file.

<!DOCTYPE html>
  
 <html>
  
    <head>
       <title>Select Element Demo</title>
    </head>
  
    <body>
    
       <datalist id="provinces"></datalist>
  
       <datalist id="counties"></datalist>
  
       <controlblock control-block-name="cb1">
          <select style="width: 100px" name="province_id"
             datalist-name="provinces">
          </select>
       </controlblock>
       
       <controlblock control-block-name="cb2">
          <select style="width: 100px" name="county_id" datalist-name="counties" 
             lookup-input-block-name="cb1" lookup-input-name="province_id">
          </select>     
       </controlblock>
       
    </body>
 </html>

Code behind File:

Create a file named selectElement.sqlx and copy/paste the code block showed below into the file.

void page.load() {      
         
         rsProvinces =   select province_name as label, province_id as value
                                         from
                                                 provinces
                                         order by
                                           province_name;
         populate_datalist('provinces', rsProvinces);
  
         rsCounties =    select county_name as label, county_id as value, province_id as province_id
                                         from
                                                 counties
                                         order by
                                           county_name;
         populate_datalist('counties', rsCounties);
 }

Controller File:

void connection_not_found(char connectionName) {
         
         if (connectionName == 'default') then
                 bool connStatus;
                 connStatus = create_oracle_connection('default', 'XE', 'htdemo', '1234'); 
         end if;
         
 }

Output:

PreviousHello World Example NextInstallation & Configuration

Last updated 4 years ago

Was this helpful?