for some reason - maybe to do with data type of underlying db column -
the values of options in your letterList cfselect have trailing spaces.
hence the arguments passed to your getTeamsByLetter() cfc method look
like this: |{"letter":"M|| ||"}|, and thus 'M %' is what your query
tries to match.add trim() around arguments.letter and that should solve the problem: select * from teams where team_name like '#trim(Arguments.letter)#%' order by team_name asc Azadi On 21/03/2010 20:15, James Milks wrote: > Hi, > Have been away from CF for a long time. Retooling a site to use more modern > features and I would like to use the CFSELECT bind features to link to select > lists. > > I followed the example by Forta on the Adobe site, but it is just not > working. have uploaded a page with the code here: > http://www.sihrhockey.org/cfc_tester.cfm > > Any help appreciated. > > James > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
