Back to YQL Forum
0

search flickrfotos by username

At first:
read today from yql and its great:)

How have to be query to find all flickr images from one user? like username='foo'
I tried it, but didn't work.

thx

by
Report Abuse
4 Replies
  • QUOTE (ragtek @ Feb 28 2009, 03:38 AM) <{POST_SNAPBACK}>
    At first:
    read today from yql and its great:)

    How have to be query to find all flickr images from one user? like username='foo'
    I tried it, but didn't work.

    thx


    You'll need to get the users "nsid" (Flickr's identifier for users), e.g.:

    CODE
    select owner.nsid from flickr.photos.info where photo_id= 2439864402


    Then you can do something like this:

    CODE
    select * from flickr.photos.search where user_id= <nsid here>
    Report Abuse
    0
  • QUOTE (Jonathan @ Mar 2 2009, 01:22 PM) <{POST_SNAPBACK}>
    You'll need to get the users "nsid" (Flickr's identifier for users), e.g.:

    CODE
    select owner.nsid from flickr.photos.info where photo_id= 2439864402


    Then you can do something like this:

    CODE
    select * from flickr.photos.search where user_id= <nsid here>


    oh so easy:D

    thx very much, seems to work
    CODE
    select * from flickr.photos.search where user_id in (select owner.nsid from flickr.photos.info where photo_id= 3231912580)


    thx:)
    Report Abuse
    0
  • Tried it, but its not working for me.

    CODE
    var url= 'http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20flickr.photos.search%20where%20user_id%20in%20(select%20owner.nsid%20from%20flickr.photos.info%20where%20photo_id%3D3268254521)&format=xml';

    		var successHandler = function(o) {
    			YAHOO.util.Dom.get('container').innerHTML = o;
    		}

    		var objTransaction = YAHOO.util.Get.script(url,
    													{ onSuccess: successHandler});

    Getting this error in firebug:
    QUOTE
    missing ; before statement
    [Break on this error] <query xmlns:yahoo="http://www.yahooapis...select+*+from+flickr.photos.search+where
    Report Abuse
    0
  • "select * from flickr.photos.search where user_id in (select owner.nsid from flickr.photos.info where photo_id= 3231912580)"

    Hmm, it works for me. You may need to encodeURIComponent on the query. Generally that error is when a query is incomplete (ie: missing quotes or malformed).

    http://query.yahooapis.com/v1/public/yql?q...&format=xml
    Report Abuse
    0
Ask a Question

Recent Posts

in YQL