ColdFusion 8 cfselect ajax features - what am I missing?

Thank you - I was sure I tried trimming, but I guess not. James 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 > >