Facebook FQL nested SELECT field value -


if have query nested query:

select name, start_time event creator in (select page_id, name place distance(latitude, longitude, "59.436961", "24.753575") < 100) limit 1 

output:

{   "data": [     {       "name": "join club – james werts live",        "start_time": "2014-06-29t23:00:00+0300"     }   ] } 

so have name of event, how can "name" field in query "place" table?

in sql, do:

select event.name, place.name event, place 

but fql quite limited , lets either select ... event or select ... place.

so in case, not able place name place table, host field event table, contains same information:

select name, start_time, host   event    creator in     (select page_id       place       distance(latitude, longitude, "59.436961", "24.753575") < 100)   limit 1 

result:

{   "data": [     {       "name": "join club – james werts live",        "start_time": "2014-06-29t23:00:00+0300",        "host": "venus club"     }   ] } 

Comments

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

Python ctypes access violation with const pointer arguments -