/[webpac2]/trunk/vhost/dipl/data.cgi
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/vhost/dipl/data.cgi

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1232 by dpavlin, Sat Jun 13 16:12:23 2009 UTC revision 1233 by dpavlin, Fri Jul 10 13:52:57 2009 UTC
# Line 11  print "Content-type: text/javascript\n\r Line 11  print "Content-type: text/javascript\n\r
11  my $dbh = DBI->connect('dbi:Pg:dbname=dipl','dpavlin','', { RaiseError => 1, AutoCommit => 0 });  my $dbh = DBI->connect('dbi:Pg:dbname=dipl','dpavlin','', { RaiseError => 1, AutoCommit => 0 });
12    
13  my $data = $dbh->selectall_arrayref(q{  my $data = $dbh->selectall_arrayref(q{
14          select sum(ttc),ca from citirani group by ca order by sum desc ;          select sum(ttc),ca,count(ca) from citirani group by ca order by count asc ;
15  });  });
16  print "var data = ",to_json(  print "var data = ",to_json(
17  #        [ map { $_->[0] } @$data ]  #        [ map { $_->[0] } @$data ]
Legend:
Removed from v.1232  
changed lines
  Added in v.1233
  ViewVC Help
Powered by ViewVC 1.1.26