I'm trying to retrieve all my friends expect few people.
I formed the query like this
SELECT uid,name FROM user WHERE uid NOT IN ($x)
Retrieve every one expect those people who are in $x.
This is giving me an fatal error Uncaught Exception: 601: Parser error: unexpected 'NOT
Thanks in advance!
"NOT IN" is not a supported feature of FQL. Ref: http://forum.developers.facebook.net/viewtopic.php?id=1420
I would suggest using something like this to get all of your friends:
And then in your script when this returns ignoring those you don't want, assuming you are using php something like:
Hope that helps.
You can use
WHERE NOT (columnName IN (things 'not in')
Like this example :