YQL Limit parameter
The yql limit parameter does not seem to be working. I've tried the
select * from xml where foo='bar' limit 10
select * from xml(10) where foo='bar'
But it seems that Ti pushes all the records through instead of 10. It works fine in the console tho.
4 Answers
-
Yeah the flickr statements are working just fine. But when i try to use a xml/json/rss file as input the user side limit 10 nor the serverside xml(10) are working in Ti. They both work fine in the YQL console.
-
Here is my statement, works perfectly with 50 items and no limitations:
select * from flickr.photos.search(50) where user_id='91041780@N00'
-
i am having the same problem, anyone solved this?
-
that's strange… my query behaves even different:
select * from xml where foo='bar' limit 50 > returns only 10 results
but
select * from xml(50) where foo='bar' > returns 50 results
for me it seems the limit parameter at the end of the statement is ignored and a default value of 10 is used, but
using select from where limit 5 returns 5 records…