0 Replies Latest reply on Oct 10, 2013 10:45 AM by LisaN

    auto-completed

    LisaN

          I am not sure how to do it.  I have the augosugess working fine from the first input field.  When i start enter the name into this box, i want other information automatic to  populate into other text boxses as well  like company , descp for this name.  Can some some pleae help?

       

       

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

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

             

              <!--- Define variables --->

              <cfset var qArt="">

              <cfset var result=ArrayNew(1)>

             

              <!--- Do search --->

            <cfquery name="qArt" datasource="art">

                select * from [dbo].[arts]

               WHERE Artname LIKE '#ARGUMENTS.search#%'

              </cfquery>

             

              <!--- Build result array --->

              <cfloop query="qArt">

             <cfset ArrayAppend(result, Artname)>

         

              </cfloop>

             

                      <!--- And return it --->

              <cfreturn result>

          </cffunction>

         

         

          <cfform action="" method="post" name="medform">

          <cfinput autosuggest="cfc:cfc.Art.lookupItem({cfautosuggestvalue})" type="text" name="Artname" size="30" typeahead="yes">

         

        

          Name<cfinput type="text" name="desc" label="desc" bind="{Artname}" ><br>

         

          Comp:<cfinput type="text" id="comp" name="comp" label="conp" bind="cfc:cfc.Art.lookupItem({Artname})" >

         

          Desc:<cfinput type="text" id="desc" name="desc" label="desc" bind="cfc:cfc.Art.lookupItem({Artname})" >

          </cfform>