Re: Error in DBD::Chart (called from DBIx::Chart)
- From: Dean Arnold <dean.arnold@xxxxxxxxxxxxx>
- Date: Fri, 19 May 2006 21:09:59 GMT
walt wrote:
I'm receiving this error message when I run a PERL script:
Use of uninitialized value in string ne at
C:/Perl/site/lib/DBD/Chart.pm line 2491.
Why does this fail? or give me this error? What does it want to be
initialized?
What is DBD:Chart want me to do in DBIx::Chart?
This is the script used to create a composite of 2 line graphs on to
one "image":
#!C:\Perl\bin\perl.exe -w
use DBIx::Chart;
use DBI qw(:sql_types);
$DSN = 'Testing';
$DATA_SOURCE = "DBI:ODBC:$DSN";
$USER_NAME = 'sa';
$PASSWORD = 'xxxxx';
$DB = 'test';
$dbh = DBIx::Chart->connect($DATA_SOURCE, $USER_NAME, $PASSWORD,
{RaiseError => 1, AutoCommit => 0})
or die "Cannot connect to $DATA_SOURCE: $DBI::errstr \n";
DBI->trace(2, 'logfile.log');
$sql = qq( select * from
(select (rtrim(PCBJOBNUMBER)+', '+ rtrim(PCBPNUM)+', '+
rtrim(LLJC_Line_Number_LONG)+', '+ rtrim(PCBTASKNUM)) as job_task,
cast(PCBESTIMATEQTY as integer) as esthrs
from $DB..pcb00125
where pcbjobnumber = 'm0603412' and pcbpnum = '001'
returning linegraph(*)
where color = 'blue' and shape = 'fillcircle') as line1,
(select (rtrim(PCBJOBNUMBER)+', '+ rtrim(PCBPNUM)+', '+
rtrim(LLJC_Line_Number_LONG)+', '+ rtrim(PCBTASKNUM)) as job_task,
cast(PCBACTUALQTY as integer) as acthrs
from $DB..pcb00125
where pcbjobnumber = 'm0603412' and pcbpnum = '001'
returning linegraph(*)
where color = 'green' and shape = 'opensquare') as line2
Ooops, I think I may have spotted the issue. IIRC, DBIx::Chart doesn't
support the 'AS' keyword for subquery aliases; so instead of
> where color = 'blue' and shape = 'fillcircle') as line1,
....and...
> where color = 'green' and shape = 'opensquare') as line2
you'll need to change to
> where color = 'blue' and shape = 'fillcircle') line1,
....and...
> where color = 'green' and shape = 'opensquare') line2
HTH,
Dean Arnold
Presicient Corp.
.
- References:
- Prev by Date: Re: Error in DBD::Chart (called from DBIx::Chart)
- Next by Date: mod_perl2 failed to install do to mod_perl
- Previous by thread: Re: Error in DBD::Chart (called from DBIx::Chart)
- Next by thread: Re: Error in DBD::Chart (called from DBIx::Chart)
- Index(es):
Relevant Pages
|
|
