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=11502.10531.15
