Concat values and Autosuggest

[Guest]

Hi,

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.
alex

Code from my cfc:

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

<cfreturn ValueList(addrQry.myAddress)>

[Dan_Bracuk]

You can't use a column alias in a where clause. Repeat the concatonation.

[Guest]

Thanks.