Similar to binding to a cfc but binding with a query on the same page. Notice the query and value attributes and how they relate to the query. I added an ” All” as a default.<\/p>\n
Similar to binding to a cfc but binding with a query on the same page. Notice the query and value attributes and how they relate to the query. I added an ” All” as a default. <cfquery name=”get_last_names” datasource=”mydsn”> select … Continue reading <cfquery name=\"get_last_names\" datasource=\"mydsn\">
\nselect distinct last_name from mytable
\nUNION ALL
\nselect ' All' as last_name
\n<\/cfquery>
\n
\n<cfform>
\n<cfselect name=\"last_name\"
\nquery=\"get_last_names\"
\nvalue=\"last_name\"
\n\/>
\n...<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"