Thank you - I was sure I tried trimming, but I guess not. James
-----Original Message----- From: Azadi Saryev [mailto:[email protected]] Sent: March 21, 2010 8:41 AM To: cf-talk Subject: Re: CF8 cfselect ajax features - what am I missing? 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:331923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
