Talk:Pages.getInfo

From Facebook Developer Wiki

Jump to: navigation, search

FQL Equivalent listed on this page "SELECT fields FROM page WHERE page_id IN (SELECT page_id FROM page_fan WHERE uid = uid AND type = type)" returns a 602 error. "fields" is not part of the table 'page'. 1181029451 12:05, 28 October 2008 (PDT)

Good catch. I think whoever wrote it meant that fields was a wildcard to be substituted by the actual fields in the table, but indicated literally. Thanks for calling this out; I see it elsewhere. -- Pete (User:563683308)
Thanks, I think it might be good to reference the FQL form in the FQL equivalent line. This would help someone see the structure, should say something like "FQL Queries are of the form SELECT [fields] FROM [table] WHERE [conditions]" 1181029451 15:39, 28 October 2008 (PDT)
The updated FQL Equivalent listed on this page "SELECT name, website FROM page WHERE page_id IN (SELECT page_id FROM page_fan WHERE uid = uid AND type = type" now returns a 604 error "Your statement is not indexable - the WHERE clause must contain one of the columns marked with a star in http://developers.facebook.com/documentation.php?doc=fql" 1181029451 15:54, 28 October 2008 (PDT)

Parameter `fields` and `page_ids` should not be provided as Arrays (PHP)

Fixed. Thanks. Pete (563683308 21:16, 15 July 2009 (PDT))
reference