Skip to main content
Inspiring
April 8, 2014
Question

Need help with auto suggest - Return multiple fields

  • April 8, 2014
  • 1 reply
  • 392 views

I am having a hard time getting my autosuggest to work. I have a cfinput where a person can type in a last name. I then want to return the full name and employee ID of the person and bind them to two different cfinputs. Here is my cfc:

<cfcomponent output="false">

 

          <cffunction name="getPerson" access="remote" returntype="array">

                    <cfargument name="search" type="any" required="false" default="">

 

 

                    <!--- Define variables --->

 

                     <cfset var data = "">

  <cfset var result = ArrayNew(2)>

  <cfset var i=0>

 

 

                    <!--- Query Location Table --->

                    <cfquery name="data" datasource="ds" cachedwithin="#CreateTimeSpan(0,14,0,0)#">

                              SELECT PERSONNEL.NAME_LAST_FIRST_MID, PERSONNEL.EMPLID, MST_LD.EMPLID

FROM MST_LD LEFT JOIN PERSONNEL ON MST_LD.SYREDU_SUID = PERSONNEL.EMPLID

WHERE ((MST_LD.PRIMARY_AFFIL_STATUS)= 'Active') AND ((MST_LD.EMPLID) Is Not Null)) AND PERSONNEL.NAME_LAST like <cfqueryparam cfsqltype="cf_sql_varchar" value="#ucase(arguments.search)#%" />

                              order by          name_last, name_first , EMPLID ASC

                    </cfquery>

 

              <cfloop index="i" from="1" to="#data.RecordCount#">

              <cftry>

         <cfset result[1]=data.NAME_LAST_FIRST_MID>

         <cfset result[2]=data.EMPLID>

         <cfcatch></cfcatch>

         </cftry>

        

      </cfloop>

       

                    <!--- And return it as a List --->

                    <cfreturn result>

          </cffunction>

</cfcomponent>

This topic has been closed for replies.

1 reply

Carl Von Stetten
Legend
April 8, 2014

So what isn't working, specifically?  What are you getting back at the client end?  Also, you might want to post the <cfform> code block so we can see if anything is wrong with the bind(s). 

Lastly, you should consider not using <cfform> and <cfinput>, for a number of practical reasons.  Here are some ideas for suitable alternatives: https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way.

-Carl V.

Message was edited by: Carl Von Stetten