Autosuggest with Different First Character Return

Looks like your cfc code is case sensitive.

yes, as Dan said, you seem to be performing case-sensitive checking of
names in your db. depending on your db, use available string
manipulation functions to convert the case. i.e. in MySQL it would be
something like:

...
WHERE LOWER(first_name) LIKE <cfqueryparam cfsqltype="cf_sql_varchar"
value="#lcase(keyword)#%"> OR LOWER(last_name) LIKE <cfqueryparam
cfsqltype="cf_sql_varchar" value="#lcase(keyword)#%">

your db's function to convert the case of column value may be different...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

> upper('#search#%')

that is not right. you are trying to use a db function on a cf variable.
it should instead be '#ucase(search)#%'

your query is probably better re-written using INNER JOIN:

SELECT v.fistname || ' ' || v.lastname name
FROM consultants_v v INNER JOIN employees_v ae ON v.employee_id =
ae.employee_id
WHERE (UPPER(v.firstname) LIKE '#UCASE(search)#%') OR (UPPER(v.lastname)
LIKE '#UCASE(search)#%')
GROUP BY v.lastname, v.firstname
ORDER BY name

btw, i am not sure you need that GROUP BY clause there at all...

and, please, DO use <cfqueryparam> tag in your queries!

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

"inner join" means the same as "join" It's also equivalent to the syntax of the query you posted.

To troubleshoot your problem, you have to run your query in circumstances where you can see debugging info. I'm guessing autosuggest is not one of those circumstances.