Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: Re: Re: Re: Yet another Uninitialized value

by nlafferty (Scribe)
on May 04, 2002 at 18:17 UTC ( [id://164039]=note: print w/replies, xml ) Need Help??


in reply to Re: Re: Re: Yet another Uninitialized value
in thread Yet another Uninitialized value

Everything looks ok in @row. Only $row[6] is undef. Here is my output:
$VAR1 = [ '26928', 'normal', '2002-04-29 15:17:06-04', '2002-04-29 15: +19:04-04', '12', '12', 'asdfsad' ]; 2002-04-29 15:17 15:19 12:12 asd +fsad $VAR1 = [ '26929', 'normal', '2002-04-29 17:18:23-04', '2002-04- +29 17:18:42-04', '12', '12', '' ]; 2002-04-29 17:18 17:18 12:12 $VAR1 = [ '26930', 'normal', '2002-05-0 +1 16:36:47-04', '2002-05-01 16:37:24-04', '14', '15', '' ]; 2002-05-01 16:36 16:37 14:15 $VAR1 = [ '26931', 'normal', '2002-05-0 +3 15:57:20-04', '2002-05-03 16:44:32-04', '12', '12', '' ]; 2002-05-03 15:57 16:44 12:12 $VAR1 = [ '26932', 'normal', '2002-05-0 +3 16:44:37-04', '2002-05-03 16:44:44-04', '12', '12', '' ]; 2002-05-03 16:44 16:44 12:12 $VAR1 = [ '26933', 'normal', '2002-05-0 +3 16:46:42-04', '2002-05-03 17:29:08-04', '12', '12', '' ]; 2002-05-03 16:46 17:29 12:12 $VAR1 = [ '26934', 'normal', '2002-05-0 +3 17:29:12-04', '2002-05-03 17:29:19-04', '12', '12', '' ]; 2002-05-03 17:29 17:29 12:12 $VAR1 = [ '26935', 'normal', '2002-05-0 +3 17:57:24-04', '2002-05-03 18:05:10-04', '13', '14', '' ];
Perhaps my SELECT statement would help?
$main::SQL="SELECT oid,* FROM timeclock WHERE username = '$username' A +ND start_stamp >= '$start_date' AND end_stamp <= '$end_date' ORDER BY + start_stamp";

Replies are listed 'Best First'.
Rex5: Yet another Uninitialized value
by IlyaM (Parson) on May 04, 2002 at 20:04 UTC
    Not sure what is the problem but couple of hints/ideas:
    • DBI returns undef if database cell contains NULL. May be there is a problem in your database.
    • There is one problem with your query. You use astersk in it but in most cases it is bad idea. Check this node and this node for explanation why.
    • One wierd thing. For me (perl 5.6.1) Data::Dumper prints undef when it encounters undefined value in data structure. In your output I see just ''. What does it mean? Well,.. I don't know :(

    --
    Ilya Martynov (http://martynov.org/)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://164039]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others avoiding work at the Monastery: (10)
As of 2024-03-28 12:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found