Skip Menu |

This queue is for tickets about the WWW-Facebook-API CPAN distribution.

Report information
The Basics
Id: 30562
Status: resolved
Priority: 0/
Queue: WWW-Facebook-API

People
Owner: unobe [...] cpan.org
Requestors: praghu2 [...] uic.edu
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in:
  • v0.0.6
  • v0.0.7
  • v0.0.8
  • v0.0.9
  • v0.1.0
  • v0.1.1
  • v0.1.3
  • v0.1.4
  • v0.1.5
  • v0.1.6
  • v0.2.1
  • v0.2.3
  • v0.3.1
  • v0.3.2
  • v0.3.3
  • v0.3.4
  • v0.3.5
  • v0.3.6
  • v0.3.7
  • v0.3.8
  • v0.3.9
  • v0.4.0
  • v0.4.1
  • v0.4.2
  • v0.4.3
  • v0.4.4
  • v0.4.5
  • v0.4.6
  • v0.4.7
Fixed in: (no value)



Subject: FQL query api rounds photo ids and album ids
my $res = $facebook->fql->query( query => "SELECT pid, aid, owner, src, src_big, src_small, link, caption, created FROM photo WHERE pid IN (SELECT pid FROM photo_tag WHERE subject='111111111') AND aid=aid AND owner='111111111'"); my $str = $res->[0]->{pid}; returns a value that is converted to an integer and rounded up like 3.10607097352343e+18. It might be because the 'pid' is getting converted to an integer where it probably should be represented as a string. The same is the case with album ids. I would greatly appreciate any support you could provide related to this issue. I am using the v0.4.7 version. Thanks.
CC: undisclosed-recipients: ;
Subject: Re: [rt.cpan.org #30562] FQL query api rounds photo ids and album ids
Date: Thu, 8 Nov 2007 06:12:39 -0800
To: via RT <bug-WWW-Facebook-API [...] rt.cpan.org>
From: David Romano <unobe [...] cpan.org>
Hello, via RT wrote on Wed, Nov 07, 2007 at 02:03:04PM PST: Show quoted text
> Wed Nov 07 17:03:01 2007: Request 30562 was acted upon. > my $res = > $facebook->fql->query( query => > "SELECT pid, aid, owner, src, src_big, src_small, link, > caption, created > FROM photo WHERE pid IN (SELECT pid FROM photo_tag WHERE > subject='111111111') AND > aid=aid AND owner='111111111'"); > my $str = $res->[0]->{pid}; > > returns a value that is converted to an integer and rounded up like > 3.10607097352343e+18. It might be because the 'pid' is getting converted > to an integer where it probably should be represented as a string. > > The same is the case with album ids. > > I would greatly appreciate any support you could provide related to this > issue. > > I am using the v0.4.7 version.
That functionality is directly dependent on the JSON module that you specify. Install JSON::DWIW and place this at the top of your file: use JSON::Any qw(DWIW); I believe using the newest versions of JSON::XS (which is usually the default) will also fix the problem. - David -- "The hardness of God is kinder than the softness of men, and His compulsion is our liberation. I did not then see what is now the most shining and obvious thing; the Divine humility which will accept a convert even on such terms. The Prodigal Son at least walked home on his own feet. But who can duly adore that Love which will open the high gates to a prodigal who is brought in kicking, struggling, resentful, and darting his eyes in every direction for a chance of escape? The words compelle intrare, compel them to come in, have been so abused by wicked men that we shudder at them; but properly understood, they plumb the depth of Divine mercy." -- C.S. Lewis, Miracles
Subject: Re: [rt.cpan.org #30562] FQL query api rounds photo ids and album ids
Date: Fri, 09 Nov 2007 18:18:28 -0600
To: bug-WWW-Facebook-API [...] rt.cpan.org
From: Preetham Raghunanda <praghu2 [...] uic.edu>
unobe@cpan.org via RT wrote: Show quoted text
> <URL: http://rt.cpan.org/Ticket/Display.html?id=30562 > > > Hello, > via RT wrote on Wed, Nov 07, 2007 at 02:03:04PM PST: >
>> Wed Nov 07 17:03:01 2007: Request 30562 was acted upon. >> my $res = >> $facebook->fql->query( query => >> "SELECT pid, aid, owner, src, src_big, src_small, link, >> caption, created >> FROM photo WHERE pid IN (SELECT pid FROM photo_tag WHERE >> subject='111111111') AND >> aid=aid AND owner='111111111'"); >> my $str = $res->[0]->{pid}; >> >> returns a value that is converted to an integer and rounded up like >> 3.10607097352343e+18. It might be because the 'pid' is getting converted >> to an integer where it probably should be represented as a string. >> >> The same is the case with album ids. >> >> I would greatly appreciate any support you could provide related to this >> issue. >> >> I am using the v0.4.7 version. >>
> That functionality is directly dependent on the JSON module that you > specify. Install JSON::DWIW and place this at the top of your file: > use JSON::Any qw(DWIW); > > I believe using the newest versions of JSON::XS (which is usually the default) > will also fix the problem. > > - David > >
Hi David, That fixes the problem ! Thanks for your quick response. Thanks, Preetham
Version 0.4.8 documentation now includes a FAQ for this.