Coldfusion Autosuggest

[Barry Mcconaghey]

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-newbie/message.cfm/messageid:4813
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15