The CFinput and Autosuggest seemed like they were going to
work great. I was trying to use this format:
<cfinput type="text" name="OP12"
get_drivers is a CFquery in the same .cfm file, and
DRIVER_NAME is a column the query returns. But the DRIVER_NAME is
last name COMMA first name: ie Emery, Scott. The valuelist takes a
comma seperated list for the autosuggest. When I run it like this,
I expect to see Emery, Scott as one of the choices, but instead I
see Emery on one line and Scott on another line. Is there a way I
can escape the comma that is between the names?
Maybe there is a better way of getting the list, or maybe I
can use a replace function to change the comma to a different
character that looks like a comma.
Thanks in advance
That didn't quite work. The result was I ended up with only
the first letter of all the last names. The documentation looks
like the dilimiter applys only to a static list, or a control where
you can set what the dilimiter is in the return set. I don't know
that you can set what the dilimiter is when the CFquery returns the
data set to the Autosuggest.