Hello. When I use this cf form below to autosuggest zip codes, it works great. But when I try to autosuggest names, it does not work.
This code works below: <!--- Search ---> <cfform action="results.cfm" method="post" name="search"> <cfquery name="ratings" datasource="#dsn#"> SELECT zip FROM fddirectory ORDER BY zip </cfquery> <!--- Convert to list ---> <cfset list=ValueList(ratings.zip)> <cfinput type="Text" name="Rating" autosuggest="#list#" size="17"> <cfinput type="submit" value=" Go " name="searchzip" /> </cfform> This code does not work: <!--- Search ---> <cfform action="results.cfm" method="post" name="search"> <cfquery name="ratings" datasource="#dsn#"> SELECT name FROM fddirectory ORDER BY name </cfquery> <!--- Convert to list ---> <cfset list=ValueList(ratings.name)> <cfinput type="Text" name="Rating" autosuggest="#list#" size="17"> <cfinput type="submit" value=" Go " name="searchzip" /> </cfform> Thanks, Barry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:326448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
