Nitedula
Posts: 22
|
| Posted: 04/25/2008, 2:16 AM |
|
Hi,
I use AJAX Feature AutoComplete on a field:
"... where cmp_name like %s_cmp_name% OR fcy_name like %s_cmp_name%"
and display {cmp_name}-{fcy_name} in the AJAX div - there this value is displayed in the text box also.
now I'd like to run an AutoFill Feature depending on this text box:
I do
"SELECT concat(cmp_name,'-',fcy_name) AS full_name
FROM facility LEFT JOIN company ON
facility.cmp_id = company.cmp_id
WHERE full_name LIKE '%{keyword}%' "
but the AutoFill does NOT work
has anybody an Idea how to solve this - I see two possibilities:
#1 display the desired Values in the AutoComplete DIV, but do NOT fill in all the Values into the text box
#2 compare the full value ("full_name") like i try with the concat(...) command
help would be much appreciated
Nitedula
|
 |
 |
|
