populate_datalist
populate_datalist
function has 1 variants:
Declaration
Description
<datalist></datalist> tag is needed in the form file.
populate_datalist
function fills the data list by using a select query result. Record set variable is used as a reference toselect
statement.There is no restriction on sql select query command column names and count. However, the
select
statement must have at least 2 columns named aslabel
andvalue
.Other columns are added to each option tag of the data list tag as additional attribute and used to filter values for a specific look up item value.
If you use "lookup-item-name" in a select tag, your data list (declared in "datalist-name" of that select tag) must have additional attribute with the same name (declared in "lookup-item-name").
Parameters
char dataListName
recordset rs
Return Value
Example
Frmx file
Sqlx file
Last updated
Was this helpful?