|
I'm trying to get a list of user's friends using fb connect for the iphone.
I've tried both of the following FQL Queries, but they don't seem to be returning anything.
which one is correct if any ?
NSString* fql = [NSString stringWithFormat:@"select flid...
Started by dizy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
NSString* fql = [NSString stringWithFormat:@"SELECT name,uid FROM user WHERE.
Figured it out...
|
|
On facebook many of you probably know of there API which uses there own FQL (facebook version of a mysql query)
I am curious, how could I support my own user submitted queries in the same manner on my site?
Do you basicly pass in the custom query into...
Started by jasondavis on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The simplest option would be to parse the queries yourself though even that will take some work.
|
|
FQL support - can I start using it ? Hi,
Has any tried to use the social-1.1.0.BUILD-SNAPSHOT? (specifically fql support)
Y
Started by yonimoses on
, 5 posts
by 2 people.
Answer Snippets (Read the full thread at springsource):
Craig Walls
Spring at FQL support and....
Given that the results of an FQL query could contain you'll have to wait a bit longer before using FQL or any other 1.1.0 feature.
On it, trying all kinds of queries against it.
|
Ask your Facebook Friends
|
I want to get my friends picture and their last status message with time.
message,time FROM status
pic_square FROM user
$status = $facebook->api_client->fql_query("SELECT message,time FROM status WHERE uid in (SELECT uid2 FROM friend WHERE uid1=...
Started by anthony on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Order by time, and limit to one result.
FQL accepts MySQL-style "ORDER BY" and "LIMIT" clauses.
|
|
On the Facebook FQL pages it shows the FQL table structure, here is a screenshot below to show some of it.
You will notice that some items are an array, such as meeting_sex, meeting_for current_location. I am just curious, do you think they are storing...
Started by jasondavis on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
The thing you have to realize about FQL is that you are not querying Facebook's main data servers directly....
FQL provides a well-designed inside their database.
User-created queries on the main database would be functional suicide.
|
|
I'm building a site that allows users to sign in using their facebook account.
I want to cache nice big versions of the users profile pictures. I know that i'm not allowed to cache images for more than 24 hours so i'm going to re-fetch the images once...
Started by Martin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Consider asking users need to store their session key in your database and make queries with that, but it will mean you.
A wrapper for querying the Photo FQL table so it follows the same rules.
|
|
Situation:
my facebook application ( http://apps.facebook.com/mymagicmirror/ ) needed to detect user's gender, and then query opposite sex or male or female
FQL:
SELECT uid, name, pic, sex FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1='.$...
Started by Unreality on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
For FQL:
from the link above but with pid=166866#p166866
One is for the en_US locale (from the post before it) and the other lets you pass in the locale you want to use, like so:
public function &fql_query.
|
|
Here are some task details:
The key functionality of service is Java socket-server (based on Red5. I know it might be overkill, but it makes me confident in future) on unix-platform (FreeBSD or Linux Debian, but I suppose, that the last one). Service ...
Started by Mixo123 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I'm not sure what you're trying to achieve here so let me try and summarise based on what I read between the lines, and give a suggestion:
Complex application (strong and wise API) Complex environment (load balancing / security model) Sounds like the ... .
|
|
I am looking to parse INSERT and UPDATE MySQL SQL queries in PHP to determine what changes where made from what original data. Now this would be pretty easy to create, but I want to see if there are any existing libraries in PHP to do this.
Basically ...
Started by Darryl Hein on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
And tokenizer)
For Perl there's more variety
Facebook released a open-source PHP version of their FQL parser.
|
|
For example I've often wanted to search stackoverflow with
SELECT whatever FROM questions WHERE views * N + votes * M > answers AND NOT(answered) ORDER BY views;
or something like that.
Is there any reasonable way to allow users to use SQL as a search...
Started by BCS on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I just thought of a strong sanitize.
See the blog post or presentation.
You will do the actual pasting together
Facebook does this with FQL .
In their conditions, but queries like your example should work.
|