Forums

hi guys
i have one dropdown with auto completer avenue
perfectly working when i register
yet when i try to read the data {var:read_data57.Data57.avenue} does not read because of db read Articles.avenue/LIKE:%{data:avenue}%
I want to maintain auto completer feature while initially read from db read it
​
table is
student name
surname
avenue
​
so it will read selected student avenue basicly when student want to change it will see previous data the he or she can change as wish with auto complater

If I'm understanding you correctly, try putting a /- at the end of the Where condition, which means "if {data:avenue} doesn't exist, skip this where condition and just get everything"

I didint put data avenue in db read
it is only in fueld value
what do you mean by if condition?
​
i want that user can see his/her previous selection then can change it with the same method as he registered
i want user can access 1000 avenues
anytime
but initially the avenue will come for example Caleno
only one Cali city avenues are from auto complater other cities are with text