JoshDG
JoshDG

Reputation: 3931

FQL Limit clause showing greater number of results than it should?

I have a simple query to show a given users photos:

SELECT pid FROM photo_tag WHERE subject in "12345" LIMIT 400,500

It returns 500 results... shouldn't it return 100?

Upvotes: 0

Views: 723

Answers (1)

cpilko
cpilko

Reputation: 11852

No. Your query is asking for 500 records starting with record 401.

To return the records 400-500 your query should read

SELECT pid FROM photo_tag WHERE subject in "12345" LIMIT 400, 100 

Upvotes: 1

Related Questions