This allows users to retrieve the values for their HTML <select> option boxes from the database using a tag. This tag asset:list allows the user to specify the attributes and it returns them in a list that can then be iterated as in the example below. The list can also be ordered using the order attribute of the tag.
The type attributes of asset:list will need to be changed to match your type as this tells that we are looking for a picklist (which is the type has been define in our example but may be different in you project). The list is the name of your output. The pubid does not need to change this gets the site id. The excludevoided can be true or false. If excludevoided is set to true then no voided(deleted) results will be returned, if set to false then all attributes will be returned. The value1 attribute is the name of the picklist. order dictates under which column to order the results.
This can then be output in a standard ics:listloop.
<asset:list type="picklists" list="resultsList" pubid='<%=ics.GetVar("site")%>' excludevoided="true" field1="picklisttype" value1='YOUR LIST NAME HERE' order="picklistvalue"/>
<ics:listloop listname="resultsList">
<ics:listget listname="resultsList" fieldname="picklistvalue" output="optionValue"/>
<option><%=ics.GetVar("optionValue")%></option>
</ics:listloop>
