If you need a multiple selection list and need to display its values dynamically from a query you can do this in one line of code within your form.<\/p>\n
To use the selected statuses after form submission you write the query using ListQualify, that returns a copy of the list, with qualifier (singlequotes) before and after the specified element(s). If you need a multiple selection list and need to display its values dynamically from a query you can do this in one line of code within your form. <cfquery name=”getstatus” datasource=”myDSN”> select All as status from orderstable UNION ALL … Continue reading <cfquery name=\"getstatus\" datasource=\"myDSN\">
\nselect All as status from orderstable
\nUNION ALL
\nselect distinct status from orderstable
\n<\/cfquery>
\n
\n<cfform ...>
\n<cfselect name=\"status\" query=\"getstatus\" value=\"status\" multiple=\"yes\" \/>
\n...
\n<\/cfform><\/code>
\nThe result is a form with a multiple selection of order statuses .<\/p>\n
\nI also set a default cfparam for status=”All”
\n<cfparam name=\"Form.status\" default=\"All\">
\n<cfquery name=\"getdata\" datasource=\"myDSN\">
\nselect * from orderstable
\n<cfif #FORM.tkt_status# neq \"All\">where status in (#ListQualify(FORM.status,\"'\")#)<\/cfif>
\n<\/cfquery> <\/p>\n","protected":false},"excerpt":{"rendered":"