CDW069
This called routine can be used to create a drop down box listing valid choices located in a file.
CALL "CDW069", W069$, HTML$
Before calling CDW069, you typically call CDS041 to obtain the template for W069$.
CALL "CDS041", "CDW069", W069$
W069$ will contain all of the input arguments to CDW069. HTML$ is the output.
| CDW069 |
| W069.FILE$ |
the name of the data file containing the validation data |
| W069.ENTFLD$ |
the field name within the template of the data file of the field to be selected on the web page |
| W069.DISFLD$ |
the name of the related field in FILE$ to be displayed (optional) |
| W069.FORMFLD$ |
if not provided, the HTML form field name will be the same as ENTFLD$. Specify FORMFLD$ when the HTML form field name must be difference from ENTFLD$ |
| W069.KNUM |
the KNUM of FILE$ to use |
| W069.KEYPFX$ |
if you only want a subset of records within the file, only keys beginning with KEYPFX$ will be included |
| W069.WHERE$ |
when a KNUM or KEYPFX$ cannot be used to determine what records in FILE$ to include, then assign this variable to a valid where clause to be used on a SELECT. Use REC.fieldname when referencing fields within the record. |
| W069.SORTBY$ |
used to alter the sequence of options within the drop down box. Note that the KNUM and KEYPFX$ arguments are ignored when either the WHERE$ or SORTBY$ arguments are used.
|
| W069.DEFAULTVAL$ |
if set to the entry field value, then this option will be selected as the default |
| W069.INCALL$ |
if passed as Y, then in addition to each of the valid options, an option will be added with a value of all *'s, and a related description of "*** Include All ***" will be added. |
| W069.INCVAL$ |
if passed as N, then the entry field will not be included in the drop down display, only the related field will appear. This is especially useful when sorting by the related field. |
| Example of Selection of State for country code US using data file
DISM02 |
0110 CALL "CDS041","CDW069",W069$
0120 LET W069.FILE$="DISM02"
0130 LET W069.ENTFLD$="STATE"
0140 LET W069.DISFLD$="NAME"
0150 LET W069.KNUM=0
0160 LET W069.KEYPFX$="US"
0170 LET W069.DEFAULTVAL$="OH"
0180 CALL "CDW069",W069$,HTML$
|
| Output HTML$ |
<select name="STATE">
<option value="AA">AA - Military-Domestic</option>
<option value="AE">AE - Military-Atlantic Area</option>
<option value="AK">AK - Alaska</option>
<option value="AL">AL - Alabama</option>
<option value="AP">AP - Military-Pacific</option>
<option value="AR">AR - Arkansas</optionn>
<option value="AS">AS - American Samoa</option>
<option value="AZ">AZ - Arizona</option>
<option value="CA">CA - California</option>
<option value="CO">CO - Colorado</option>
<option value="CT">CT - Connecticut</option>
<option value="DC">DC - District of Columbia</option>
<option value="DE">DE - Delaware</option>
<option value="FL">FL - Florida</option>
<option value="FM">FM - Federated Sates of Micrones</option>
<option value="GA">GA - Georgia</option>
<option value="GU">GU - Guam</option>
<option value="HI">HI - Hawaii</option>
<option value="IA">IA - Iowa</option>
<option value="ID">ID - Idaho</option>
<option value="IL">IL - Illinois</option>
<option value="IN">IN - Indiana</option>
<option value="KS">KS - Kansas</option>
<option value="KY">KY - Kentucky</option>
<option value="LA">LA - Louisiana</option>
<option value="MA">MA - Massachusetts</option>
<option value="MD">MD - Maryland</option>
<option value="ME">ME - Maine</option>
<option value="MH">MH - Marshall Islands</option>
<option value="MI">MI - Michigan</option>
<option value="MN">MN - Minnesota</option>
<option value="MO">MO - Missouri</option>
<option value="MP">MP - Northern Mariana Islands</option>
<option value="MS">MS - Mississippi</option>
<option value="MT">MT - Montana</option>
<option value="NC">NC - North Carolina</option>
<option value="ND">ND - North Dakota</option>
<option value="NE">NE - Nebraska</option>
<option value="NH">NH - New Hampshire</option>
<option value="NJ">NJ - New Jersey</option>
<option
value="NM">NM - New Mexico</option>
<option value="NV">NV - Nevada</option>
<option value="NY">NY - New York</option>
<option value="OH" selected>OH - Ohio</option>
<option value="OK">OK - Oklahoma</option>
<option value="OR">OR - Oregon</option>
<option value="PA">PA - Pennsylvania</option>
<option value="PR">PR - Puerto Rico</option>
<option value="PW">PW - Palau</option>
<option value="RI">RI - Rhode Island</option>
<option value="SC">SC - South Carolina</option>
<option value="SD">SD - South Dakota</option>
<option value="TN">TN - Tennessee</option>
<option value="TX">TX - Texas</option>
<option value="UT">UT - Utah</option>
<option value="VA">VA - Virginia</option>
<option value="VI">VI - Virgin Islands</option>
<option value="VT">VT - Vermont</option>
<option value="WA">WA - Washington</option>
<option value="WI">WI - Wisconsin</option>
<option value="WV">WV - West Virginia</option>
<option value="WY">WY - Wyoming</option>
</select>
|
| Execution example: |
|
|
