I have an autosuggest field on a form that displays a list of
names. The form works fairly well when using
valueList(query.column) but my real problem is that within the
database the column contains "lastname , firstname MI" where the
last name is followed by a comma. ValueList strips everything after
the comma so my list only displays and populates last names. I need
the whole field since there are over 4000 names in the database and
"Smith" occurs more than once. The user won't know which "Smith"
he's selecting. In the cfc I've tried removing valueList but this
only populates one name in the drop down box. It defeats the
purpose of having an autosuggest field if only one name shows up.
Any suggestions? thanks, Wendy