JM [mailto:[EMAIL PROTECTED] wrote: > $sth_smart_hits->bind_columns( undef, \$tf1, \$tf2, \$tf3, \$tf4, \$tf5, > \$tf6, \$tf7, \$tf8, \$tf9, \$tfa, \$tfb, \$tfc, \\ > $tfd ); > > This is line 104 -> print "$tf1, $tf2, $tf3, $tf4, $tf5, $tf6, $tf7, $tf8, > $tf9, $tfa, $tfb, $tfc, $tfd" . "\n"; > > > but it gives me this error.. > > Use of uninitialized value in concatenation (.) or string at > ./send-telco-stats.pl line line 104
That's not an error, that's a warning. It occurs because one of the columns you are fetching has a NULL value, which becomes undef in Perl. You can use NVL() in the SQL, or defined() in the Perl code, to change it to a defined value. Ronald
