SQL CheckBoxList

v4.1.0

Use the results of a SQL expression to generate options for a CheckBoxList. The selected values can either be stored in a CSV or an XML fragment.

Configuration

The SQL Expression must return two columns: a 'Text' field that's used for the visible text and a 'Value' field that's used to identify an item. The parameter (or token) @currentId can be used in the SQL, and will be substituted with the id of the Document / Media or Member that the datatype is a property on.

The Connection string is configured via a drop down selection, which defaults to the current Umbraco database. If there are connection strings defined in the web.config, these become selectable options. (The connection string name is stored, so migration between environments can all be controlled via the web.config).

<configuration>
  <connectionStrings>
    <add name="" connectionString="server=;database=;user id=;password=" />
  </connectionStrings>
</configuration>

The Storage Type can be either a CSV or XML fragment of the selected values.

Last edited Sep 3, 2012 at 11:18 PM by Hendy, version 9