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";
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.