after I tried half a day, I try it here. I got trouble with a
join request on a database. I tried the request themself on the
sqlite manager and it works. I got the result and I'm able work
with the data from the "part_list" but not able to get the result
from the "list":
SELECT DISTINCT list.no, list.info, part_list.* FROM list join
part_list on list.no = part_list.no WHERE list.code ='XYZ' AND
['description']); => WORKED, Column from table "part_list"
- alert(result.data['list.info']; => DON'T WORKED,
Column from table "list"
It doesn't look like your syntax is quite right to me. The
result.data property is an Array. Unless you use "as" in your field
list or have the long format set the field should be just the field
name. Try the following result.data.info.