Using PickList for HTML select -

Dermot Butterfield - 05 September 2015

tl;dr

Using PickList for HTML select

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>

Contact Us

I hope you found this useful or if you have any questions don't hesitate to leave a comment or contact support[@]tomred[.]net

Articles

Java

This what I have spent most of my time working in over the years and these are the little bits of logic or snippets I have come across. Some of these are things I have needed to search for or I have found I needed to feedback on code reviews.

Oracle WebCenter (FatWire)

During my time working in consulting I was tasked many times with delivering FatWire sites. I took notes due to the lack of useful documentation at the time. These are the results of those notes made and shared.

CSS HTML JS

I believe the majority of time on a project is spent with the UI. Web is no exception. I have compiled a set of articles covering HTML, CSS and JS with the intention of taking the sting out of this work.

DevOps

A space dedicated to all those things you need to know beyond writing code. This covers Linux, Windows, Git and SVN among other hopefully useful nuggets.

Security

I picked up some pointers over the years consulting for government and banking sectors before entering a PCI DSS development environment. This section covers aspects like coding, testing, code review and best practice.

Apps

Apps is a section which offers access to bits and pieces I have put together over the last few years. This includes Random Password Generator and Base64 Encoder.