oh wow that was weird... all those | in my pasted firebug output...
in any case, look at the generated html source of your page and you will
see the options in first cfselect all have lots of trailing whitespace.
Azadi
On 21/03/2010 20:40, Azadi Saryev wrote:
> 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:331922
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
