Autosuggest not displaying the primary key when i concat.
Autosuggest not displaying anything when i concat the primary Key with the contents of other columns. It will work fine when i not include the name.personID concat syntax. but whenever i include the name.personID syntax it does not autosuggest, the syntax is below. any ideas...
<cfquery name="FOILIST" datasource="master">
SELECT CONCAT(name.personID,' ',name.fname,' ',name.last,' ',name.nickname) AS workers
FROM name
ORDER BY name.fname
</cfquery>
<cfset list=valuelist(workerLIST.worker)>
<cfinput type="text" name="foiid" autosuggest="#list#" value="" size="32" />
