In Facebook query language(FQL), you can specify an IN clause, like:
SELECT uid1, uid2 FROM friend WHERE uid1 IN (1000, 1001, 1002)
Does anyone know what's the max number of parameters you can pass into IN?
Thanks.
views:
170answers:
2
A:
There shoud not be a maximum number of parameters as there isnt in SQL IN as far as I know.
http://www.sql-tutorial.net/SQL-IN.asp
just dont use more parameters than you have values for the function to check because you will not get any results (dont know if it will give away an error as I never tried to).
TheChange
2010-02-26 08:18:32
I believe there is a limit.
Faruz
2010-03-21 07:57:09
@Faruz: I dont really know, just guessed. Any Solution outrunning the limit maybe should be done in a better way
TheChange
2010-03-22 14:46:38
In some SQL servers, the limit is the length of strings their SQL parser can handle, not the number of items in the "IN" clause. I'm not sure what the specific query-length limits are though.
Mark B
2010-03-31 20:41:57
I'm going from the facebook developer boards http://forum.developers.facebook.com/viewtopic.php?pid=216570
Ceilingfish
2010-05-05 09:40:11