Creating a data based derived dropdown list bound to a record for Search or Edit form is sometimes needed. For search you may want to return All as your first item in the dropdown, but for edit mode you likely want to return the actual value you searched for or the actual value already existing in the database. Imagine you are maintaining a Store list for a retail sales company and need to search\/Edit\/Copy\/Update records using one form. <\/p>\n
This is a solution I came up with using a CFSELECT element bound to a CFC. Note brackets have been removed.<\/p>\n
form.cfm<\/strong> CFC<\/strong> cfquery datasource=\"#REQUEST.Source#\" name=\"qs\" cfreturn qs <\/p>\n \/cffunction Creating a data based derived dropdown list bound to a record for Search or Edit form is sometimes needed. For search you may want to return All as your first item in the dropdown, but for edit mode you likely … Continue reading
\n
\n\/\/set a default to return all results. get_storelist('#storenum#') is what passes ALL or a selected store number
\ncfparam name=\"storenum\" default=\"All\"
\ncfform name=myform
\nlabel for=\"storenum\" \/\/a label
\ncfselect name=\"mylist\" bind=\"CFC:get_storelist('#storenum#')\"<\/strong> bindonload=\"yes\" value=\"storenum\" display=\"storeloc\" \/cfselect
\n...
\n\/cfform
\n<\/code><\/p>\n
\n
\ncffunction name=\"get_storelist\" access=\"remote\" returntype=\"query\" hint=\"Get a list of stores\"
\ncfargument name=\"store_passed\" default=\"All\"
\n cfset var qs = \"\"<\/p>\n
\n select '#store_passed#' as storenum, ''as storeloc, 1 as sortby
\n UNION
\n select distinct storenum, storenum+city+state as storeloc, 2 as sortby from store_table
\n order by sortby, storenum
\n \/cfquery<\/p>\n
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"