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";
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
|
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.