2 Replies Latest reply on Aug 21, 2008 3:07 PM by alexford

    Concat values and Autosuggest


      I'm wondering if it is possible to send concat values from a query to autosuggest. So far I have been unsuccessful. Any ideas would be appreciated.

      many thanks.

      Code from my cfc:

      <cfquery name="addrQry" datasource="myDB">
      select DIR+' '+STREET+' '+TYPE as myAddress
      from myTbl
      where UCase(myAddress) like Ucase('#ARGUMENTS.search1#%')

      <cfreturn ValueList(addrQry.myAddress)>