Hello, > It looks like not all of the fields have something in them. Perl is taking blanks for > undefined for some reason.
An empty field in a database is not a "blank", as you say, but a NULL. Meaning it's not just blank, but effectively inexistant - there is no value, not even the empty string, which would be a "blank". DBI translates a NULL value as undef, which means pretty much the same thing in Perl. That's why you're seeing some undef warnings, because you're getting some NULL values. So you either have to check for them, or replace all NULL values in your DB with "" (empty string, which is empty but defined) - but you may not want to do that for other reasons. Of course, if you can't make that decision because you don't administer the database, then you'll have to check for undef each time (unless your table specifies a field as NOT NULL, meaning that the field cannot be NULL and the database engine will enforce that rule). Hope that helps, J-S -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
