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.
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
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…