[EMAIL PROTECTED] wrote:
Hi list,
I tried to produce a 3D barchart with DBD::Chart thanks to this code
sample (source: Perl for Oracle DBAs, ORA):
Could you send me (not the list) copies of the images ?
I can't promise much, as I'm on my way out the door for a long
vacation, b
Hi list,
I tried to produce a 3D barchart with DBD::Chart thanks to this code
sample (source: Perl for Oracle DBAs, ORA):
--snip--
use DBI;
use strict;
my $dbh= DBI->connect('dbi:Chart:', undef, undef, { PrintError => 1,
RaiseError => 1 });
$dbh->do('CREATE TABLE spir
0
serie_1 = .72
serie_1 = 0
serie_1 = 0
serie_1 = .68
serie_1 = .98
OK, it looks like its the fractionals wo/ leading zero. Which is a bug
in DBD::Chart.
So rather than modifying the regex, here's some patches to replace
it with a better test:
At Chart.pm line 1570, change
us
THIAGO LACERDA ZAGO wrote:
Good morning!
Dean,
I'm using DBD::Chart version that I downloaded from I don't remember exactly
where, but it is this one: DBD-Chart-0.82.tar.gz.
I read thoroughly the README.txt file and proceeded exactly as its
recommendations.
The array bond is the
CERDA ZAGO
Cc: dbi-users@perl.org
Subject: Re: DBD::Chart copying and pasting...
THIAGO LACERDA ZAGO wrote:
> When I copy and paste the image on my Excel Worksheet or PowerPoint
> right from my browser after running my DBD::Chart Perl script, the
> image comes with its background all in
Hi Dean,
Thanks again for your prompt reply.
I'm currently using the DBD::Chart version DBD-Chart-0.82., GD-2.35, PERL
Version 5.8.0.
Firstly, I was saving with the PNG format, then I changed to GIF, but with no
avail.
I've set my Background to transparent.
Here is a piece of co
THIAGO LACERDA ZAGO wrote:
When I copy and paste the image on my Excel Worksheet or PowerPoint
> right from my browser after running my DBD::Chart Perl script, the
> image comes with its background all in black and the graph
> hard to distinguish from the original.
What could I do to
THIAGO LACERDA ZAGO wrote:
Whenever when I try to plot a percentage value, I get these erros.
DBD::Chart::st execute failed: Supplied value not compatible with target field at parameter 1.
> at gv_ind_1_18.pl line 147.
Can't take log of -2e+38 at /usr/lib/perl5/site_perl/5.8.0/D
Hi,
When I copy and paste the image on my Excel Worksheet or PowerPoint right from
my browser after running my DBD::Chart Perl script, the image comes with its
background all in black and the graph hard to distinguish from the original.
What could I do to overcome this problem?
Thanks
I’mean multiply SERIES_VAL_1 by 10 and not SERIES_CAT as mentioned before.
Tks!
Thiago
_
From: THIAGO LACERDA ZAGO
Sent: quarta-feira, 3 de janeiro de 2007 11:46
To: 'Dean Arnold'
Cc: dbi-users@perl.org
Subject: DBD::Chart::st execute failed
Whenever whe
Whenever when I try to plot a percentage value, I get these erros.
DBD::Chart::st execute failed: Supplied value not compatible with target field
at parameter 1. at gv_ind_1_18.pl line 147.
Can't take log of -2e+38 at /usr/lib/perl5/site_perl/5.8.0/DBD/Chart/Plot.pm
line 1591.
THIAGO LACERDA ZAGO wrote:
Do you have any idea how a I can plot a secondary y-axis
scale like we do in MS-Excel to express in the scalar values
on the left hand and absolute on
> the right eg. Percentage values ?
Sorry, no.
Regards,
Dean Arnold
Presicient Corp.
Do you have any idea how a I can plot a secondary y-axis scale like we do in
MS-Excel to express in the scalar values on the left hand and absolute on the
right eg. Percentage values ?
Currently, I can see that DBD::Chart reference
(http://www.presicient.com/dbixchart/) only provides means of
The subject maintenance releases of DBIx::Chart and DBD::Chart
are now (or soon should be) available on CPAN. These releases
fix a problem with some DBD's/DBMS's that don't support multiple
concurrent execute()'d, but un-fetch()'d, statement handles on a single
connecti
* Dean Arnold <[EMAIL PROTECTED]> [2005-04-25 18:00]:
> Wojciech Pietron wrote:
> >Hello,
> >
> >does anybody on this list use DBD::Chart?
> >
> >I have the problem that concerns modifying HTML imagemap elements. I
> >have barchart on depts' cos
Wojciech Pietron wrote:
Hello,
does anybody on this list use DBD::Chart?
I have the problem that concerns modifying HTML imagemap elements. I
have barchart on depts' costs. When I click on a bar I have dept's name
in :X parameter and its cost value in :Y. But I would like to have
de
Hello,
does anybody on this list use DBD::Chart?
I have the problem that concerns modifying HTML imagemap elements. I
have barchart on depts' costs. When I click on a bar I have dept's name
in :X parameter and its cost value in :Y. But I would like to have
deptid in :X instead of
> polled point before the break and after .
> eg 10,12,3,4,5,NULL,NULL,NULL,25
No. At present DBD::Chart simply interpolates thru NULL pts.
Not certain how to handle that "heuristically"; however, the app can
provide that by treating the discontinuity as a separate graph (ie,
supply
MRTG uses RRD thereby making it difficult to plot pinpoint data.
RRD aggregates on its own i want to see data down too 5 minutes say after a
year.
So i decided to go with cgi/perl/dbi/dbd::chart/dbd::mysql
-Original Message-
From: Sumitro Chowdhury [mailto:[EMAIL PROTECTED]
Sent
OT, but doesn't MRTG ( http://people.ee.ethz.ch/~oetiker/webtools/mrtg/
) work for you ?
Sumitro.
On Wed, 2004-04-07 at 08:54, Rajdeep Singh CHIMNI wrote:
> Hi people,
>
> I am trying to graph a line chart of bandwitdh utilization.see attachment.
>
> 1)The x axis is determined by the module i
Hi people,
I am trying to graph a line chart of bandwitdh utilization.see attachment.
1)The x axis is determined by the module itself.
Is there anyway i can override this and determine my own x axis.
Can i have say points every hour with markers every four harrs in a daily graph.
2)the legend als
Has anyone built this, I'm getting this error when trying to build the
pre-requisite package gdtextUtil-0.80 :-
bash-2.05b$ perl Makefile.PL
Checking if your kit is complete...
Looks good
C:\cygwin\bin\perl.exe: *** unable to remap C:\cygwin\bin\cygpng12.dll to
same address as parent(0xB9) !
D
> TITLE = '2002 Widget Sales By Region' AND
> COLOR IN ('red', 'green', 'blue', 'lyellow', 'lpurple') AND
> BACKGROUND='lgray' AND
> SIGNATURE='Copyright(C) 2001, GOWI Systems, Inc.'");
>
GROUND='lgray' AND
SIGNATURE='Copyright(C) 2001, GOWI Systems, Inc.'");
$rsth->execute;
$rsth->bind_col(1, \$buf);
$rsth->fetch;
In support of DBIx::Chart, I've also released DBD::Chart 0.80,
which provides some extensions to support DBIx::Chart, as well
as cor
DBD::Chart 0.73 is now available at both
CPAN and www.presicient.com/dbdchart.
Ths release fixes a number of bugs introduced
in 0.72:
- fixed scaling of 3-D barcharts
- added axis labels for 3-D barchart
- improved rendering of single point
line/point graphs and barcharts
DBD::Chart 0.71 is now available at www.presicient.com/dbdchart, and should
be available on CPAN shortly.
DBD::Chart is a Perl DBI driver that uses a simple SQL syntax to render
graphs and charts.
Version 0.71 includes the following features/fixes:
- fixed LINEWIDTH property to be applied to
I'm pleased to announce the release of DBD::Chart 0.61,
a Perl DBI Driver for rendering charts and graphs.
This release includes the following fixes and feature
enhancements:
- fix multicolor histograms
- fix :PLOTNUM escape processing for HTML imagemaps
- improved SQL syntax compatib
I'm pleased to announce the availability of
DBD::Chart 0.60, a Perl DBI driver abstraction
for rendering charts and graphs using a simple
SQL syntax.
Release 0.60 includes the following updates:
- support for histograms (sideways barcharts),
both 2-D and 3-D, and 3 axis
- suppor
DBD::Chart 0.52 should be available shortly on
CPAN, and has been available at www.presicient.com/dbdchart.
This release fixes several bugs (many thanks to Terry Jones
for finding these) and adds support for 3-D piecharts
and multicolor, single range barcharts.
Regards,
Dean Arnold
DBD::Chart 0.51 is now available from either
http://www.presicient.com/dbdchart/ or from CPAN (shortly).
Changes from 0.50:
- added 3-D piechart support
- support for multicolor barcharts (ala GD::Graph::bars)
FYI: DBD::Chart is a Perl DBI driver abstraction for rendering charts
and graphs
DBD::Chart 0.50 is now available from either
http://www.presicient.com/dbdchart/ or from CPAN (shortly).
Changes from 0.43:
- added 3 axis bar charts
- GD::Graph, GD::Graph3d no longer required (DBD::Chart::Plot includes
its own barchart, piechart rendering engine)
- added box & whi
A new version of DBD::Chart is available at www.presicient.com/dbdchart
and should soon appear on CPAN. This release includes support
for GIF formats for both logo and output images, via older (unsupported)
versions of the various GD modules/libraries.
(Many thanks to Peter Scott for contributing
DBD::Chart 0.42 is now available from either
http://www.presicient.com/dbdchart/ or from CPAN (shortly).
Changes from 0.41:
- fix to support 'X-ORIENT=HORIZONTAL' on candlestick charts
and symbolic domains
FYI: DBD::Chart is a Perl DBI driver abstraction for rendering charts
Thanks for the replies! (Especially you, Dean :)
I finally got it to work. YAY!
Here's the code that worked if anyone is interested:
#! /usr/bin/perl -wT
use CGI;
use DBI;
use CGI::Carp qw(fatalsToBrowser);
$dbh = DBI->connect("DBI:mysql:mydatabase", "username", "password") || die
$DBI::err
>
> ### form sql statement ###
> $graphsql = "SELECT loc_id, elevation, date FROM mrddaily
> WHERE loc_id = 1 AND date <= 20010105 AND date >= 20010101";
>
> ### prepare and execute query ###
> $sth = $dbh->prepare($graphsql);
> $sth->exe
1 AND date <= 20010105 AND date >= 20010101";
### prepare and execute query ###
$sth = $dbh->prepare($graphsql);
$sth->execute();
### store query results ###
while (@ary = $sth->fetchrow_array()) {
if (@ary[0] == 1) {
push (@y, @ary[1]);
$ycount++;
pus
Hello,
I was wondering if anyone has some code that they know works using DBD::Chart
that I could test my installation with?
I'd really like something simple so I can see how it works. Any help would
be appreciated.
Michelle Donahue
DBD::Chart 0.41 is now available from either
http://home.earthlink.net/~darnold/dbdchart/ or from CPAN (shortly).
Changes from 0.40:
- fix to strip quotes from string literal in INSERT stmt
- fix for literal data index in prepare of INSERT
- fix for Y-axis tick alignment when no grid is
DBD::Chart 0.40 is now available from either
CPAN or at http://home.earthlink.net/~darnold/dbdchart/.
Changes from 0.30:
- add Y-MAX and Y-MIN properties for barcharts
- fixed problem with last column definitions in CREATE TABLE
- fixed problem with FORMAT property
FYI: DBD::Chart is a
DBD::Chart 0.30 is now available from either
CPAN or at http://home.earthlink.net/~darnold/dbdchart/.
Changes from 0.20:
- strip newlines from SQL for prepare()
- add BACKGROUND property to set background color,
incl. transparent background
- add FORMAT property to select
Cool!
Tom
On Thu, Mar 15, 2001 at 09:09:58AM -0800, Dean Arnold wrote:
> DBD::Chart 0.20 is now available on CPAN. This module
> provides a DBI abstraction for rendering charts and graphs.
> For more information, see
> http://home.earthlink.net/~darnold/dbdchart/
>
> Rega
DBD::Chart 0.20 is now available on CPAN. This module
provides a DBI abstraction for rendering charts and graphs.
For more information, see
http://home.earthlink.net/~darnold/dbdchart/
Regards,
Dean Arnold
Its nearly ready, just a few tests and some packaging left, so I'm looking
for alpha testers.
DBD::Chart puts a DBI frontend on GD::Graph and Chart::Plot,
using a simple SQL dialect. Check out http://home.earthlink.net/~darnold/dbdchart/
for details.
If you're interested in tryin
f a mishmash of hashes,
and I wanted to try to leverage an existing, documented, widely
disseminated interface specification, rather than throw yet
another interface spec on the already teetering pile. Being
a DBMSgeek, DBI seemed the obvious solution.
I suppose some could argue DBD::Chart just tos
[EMAIL PROTECTED]>
> To: "DBI-users" <[EMAIL PROTECTED]>; "DBI-dev" <[EMAIL PROTECTED]>
> Sent: Monday, February 05, 2001 4:42 AM
> Subject: DBD::Chart ?
>
>
> "The more I do DBD, the more DBDs I do."
> - Frank Sinatra (paraphr
confusing to
build charts with SQL statements.
I like your qoute at the beginning!
-ren
- Original Message -
From: "Dean Arnold" <[EMAIL PROTECTED]>
To: "DBI-users" <[EMAIL PROTECTED]>; "DBI-dev" <[EMAIL PROTECTED]>
Sent: Monday, Februa
Dean Arnold wrote:
> but wants to move data
> from any of Excel files, CSV files, databases,
> formatted binary files, XML docs, etc. to any of Excel files, CSV files,
> binary files, XML, databases, charts, etc. Using the DBI
> interface provides a nice base class for plugging things together
> w
users" <[EMAIL PROTECTED]>;
"DBI-dev" <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 12:56 PM
Subject: Re: DBD::Chart ?
> At 12:42 PM 2/4/2001 -0800, Dean Arnold wrote:
> >"The more I do DBD, the more DBDs I do."
> >- Frank S
GD::Graph modules
>to render charts from database rowsets, but feel like
>there's an impedance mismatch between DBI
>and the charting packages...so I'm whipping up a
>DBD::Chart to try and rectify the situation.
>
>If anyone sees anything wrong with this, or has some
>
there's an impedance mismatch between DBI
and the charting packages...so I'm whipping up a
DBD::Chart to try and rectify the situation.
At present, the idea is to use "CREATE TABLE..."
like syntax to establish the graph domain info,
use "INSERT..." syntax to add data poin
50 matches
Mail list logo