Filtering cfselect data

Yup, it's possible and better yet, easy! [insert all kinds of disclaimers here]

You can bind CFSELECT to a .cfc component which returns the options you want.

And you can give the .cfc an argument, which is the value of a search box.

Example:

test.cfm

<cfform name="form1">
    <cfinput type="text" name="searchterm">
    <cfselect name="myoption" bind="cfc:queryoptions.search({form1:searchterm})"

bindonload="true" value="mytext"></cfselect>
</cfform>

queryoptions.cfc

<cfcomponent >
    <cffunction name="search" returnformat="json" access="remote" >
        <cfargument name="searchterm">
       
        <cfset q = queryNew("myvalue,mytext","varchar,varchar")>
        <cfloop from="65" to="90" index="c">
        <cfset queryAddRow(q)>
        <cfset querySetCell(q,"myvalue",c)>
        <cfset querySetCell(q,"mytext",lcase(repeatstring(chr(c),5)))>
        </cfloop>
       
        <cfquery name="qoq" dbtype="query" >
        SELECT myvalue,mytext FROM q
        <cfif trim(arguments.searchterm) neq "">
        WHERE lower(mytext) LIKE '#lcase(arguments.searchterm)#%'
        </cfif>
        </cfquery>
       
        <cfreturn qoq>
    </cffunction>
</cfcomponent>

There you go. A working example.

The .cfc is unnecessarily long, because I first created query data from scratch. 25 rows, values from AAAAA, BBBBB to ZZZZZ. Then I emulate the "real" query (you're going to have) by doing a QueryOfQuery of the querydata (representing the data in your database).

In real life, you just need one query. Make sure your search is case insensitive (as I did in the example).

Hope this helps with ColdFusion bindings. They rule.

Edit: the select does not re-populate before the search field unfocuses. This would do the trick:  onkeyup="this.blur();this.focus();" but it's really an awful haxx, and is not guaranteed to work correctly at all. There should be a better way to do this, but I haven't checked if and how BINDs can be activated "remotely" from javascript.

--

-Fernis - fernis.net - ColdFusion Developer For Hire