<html>
<body>
<font face="Arial, Helvetica">Okay, instead of just returning the first 3
records, I modified it to print the whole line of records but now it acts
up....<br>
My database is 36 records wide and when I run it, I get:<br><br>
</font>[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value
in concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID
DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID
DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID
DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID
DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID
DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
[Wed Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID
DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID
DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID
DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID
DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID
DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,VALID DATA,<br><br>
<font face="Arial, Helvetica">Etc.<br><br>
Why am I getting <br>
</font><x-tab> </x-tab>[Wed
Oct 18 18:52:56 2006] dbquery.pl: Use of uninitialized value in
concatenation (.) or string at ./dbquery.pl line 34.<br>
<font face="Arial, Helvetica"><x-tab> </x-tab><x-tab> </x-tab>...
and then correct data!?!?!<br><br>
<br><br>
HERE's the Proggy<br>
--------------------------------------------------<br>
</font>#!/usr/bin/perl -wT<br>
use CGI qw(:standard);<br>
use CGI::Carp qw(warningsToBrowser fatalsToBrowser);<br>
use DBI;<br>
use strict;<br><br>
<br>
my $dbdriver = $ARGV[0];<br>
my $db = $ARGV[1];<br>
my $dbuser = $ARGV[2];<br>
my $dbpasswd = $ARGV[3];<br>
my $dbtable = $ARGV[4];<br>
my $condition = $ARGV[5];<br><br>
my @row_array;<br>
my $row;<br><br>
<br>
if ( $#ARGV ==5 )<br>
<x-tab> </x-tab>{<br><br>
<x-tab> </x-tab><x-tab> </x-tab>my
$dbh = DBI->connect(
"DBI:$dbdriver:$db",$dbuser,$dbpasswd,)<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>||
die "Database connection not made: $DBI::errstr";<br>
<x-tab> </x-tab><x-tab> </x-tab><br>
<x-tab> </x-tab><x-tab> </x-tab><br>
<x-tab> </x-tab><x-tab> </x-tab>my
$sth = $dbh->prepare("SELECT * FROM $dbtable WHERE
$condition")<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>or
die $dbh->errstr;<br>
<x-tab> </x-tab><x-tab> </x-tab>$sth->execute()
or die $dbh->errstr;<br>
<x-tab> </x-tab><x-tab> </x-tab><br>
<x-tab> </x-tab><x-tab> </x-tab>while
(@row_array = $sth->fetchrow_array)<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>{<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>foreach
$row (@row_array)<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>{<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>print
"$row,"; # <------ THIS IS LINE 34<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>}<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>print
"\n";<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>}<br>
<x-tab> </x-tab><x-tab> </x-tab>$dbh->disconnect();<br>
<x-tab> </x-tab>}<br>
<x-tab> </x-tab>elsif (
$#ARGV <= 4 ) {<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"\n-----------------------------ERROR------------------------------\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"NOT ENOUGH ARGUMENTS\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"dbquery.pl usage: dbquery.pl DBDRIVER DB DBUSER DBPASSWORD DBTABLE
\"CONDITION\"\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"NOTE: DBDIVER is usually \"mysql\" but it can be other
things like \"oracle\".\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
" EXAMPLE: dbquery.pl mysql
databas...\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"NOTE: The total CONDITION must be in quotes with the matching data
in single quotes. \n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
" EXAMPLE: \"product LIKE
'bicycle'\"\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"---------------------------END
ERROR----------------------------\n\n";<br>
<x-tab> </x-tab>}<br>
<x-tab> </x-tab><x-tab> </x-tab>else
{<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"\n-----------------------------ERROR------------------------------\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"TOO MANY ARGUMENTS\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"dbquery.pl usage: dbquery.pl DBDRIVER DB DBUSER DBPASSWORD DBTABLE
\"CONDITION\"\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"NOTE: DBDIVER is usually \"mysql\" but it can be other
things like \"oracle\".\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
" EXAMPLE: dbquery.pl mysql
databas...\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"NOTE: The total CONDITION must be in quotes with the matching data
in single quotes. \n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
" EXAMPLE: \"product LIKE
'bicycle'\"\n";<br>
<x-tab> </x-tab><x-tab> </x-tab>print
"---------------------------END
ERROR----------------------------\n\n";<br>
<x-tab> </x-tab>}</body>
</html>