Autosuggest not displaying the primary key when i concat.

[College Kid]

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" />

[Dan_Bracuk]

I suggest that you start by looking at your query results.  Unless personId is a text field of some sort, your query might actually be crashing.

[BKBK]

Shouldn't it be <cfset list=valuelist(FOILIST.workers)> ?