开发者

How to write fql query for images of specific album

开发者 https://www.devze.com 2023-04-05 00:06 出处:网络
I need to retrieve src_small images. NSString *query=[NSString stringWithFormat:@\"SELECT pid,src_small,src_big FROM photo WHERE aid IN ( SELECT aid FROM album WHERE owner=%@)\",ownerId];

I need to retrieve src_small images.

NSString *query=[NSString stringWithFormat:@"SELECT pid,src_small,src_big FROM photo WHERE aid IN ( SELECT aid FROM album WHERE owner=%@)",ownerId];

I wrote this query, and this works fine. But it gives me data of all the albums.

What i want is to retrieve images for specific album only, not for all the albums.

How should i reframe my query to solve this?

Thanks in advance开发者_C百科.


obviously:

NSString *query = [NSString stringWithFormat : @"SELECT pid, src_small, src_big FROM photo WHERE aid = '%@'", aId];  

hope this helps

0

精彩评论

暂无评论...
验证码 换一张
取 消