Skip to main content
Inspiring
November 26, 2010
Question

Autosuggest not displaying the primary key when i concat.

  • November 26, 2010
  • 2 replies
  • 498 views

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

    This topic has been closed for replies.

    2 replies

    BKBK
    Community Expert
    Community Expert
    November 28, 2010

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

    Inspiring
    November 26, 2010

    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.