Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^3: DBIC intermittently returning rows missing date_time value

by reasonablekeith (Deacon)
on Jun 29, 2009 at 11:00 UTC ( [id://775617]=note: print w/replies, xml ) Need Help??


in reply to Re^2: DBIC intermittently returning rows missing date_time value
in thread DBIC intermittently returning rows missing date_time value

As said, looks fine to me.
SELECT me.id, me.name, me.date_time, me.status_code, me.time_taken FRO +M tests me WHERE ( ( ( date_time <= ? AND date_time >= ? ) AND name = ? ) ) ORDE +R BY date_ time: '2009-06-24 23:59:59', '2009-06-24 00:00:00', 'ART_CRV' Use of uninitialized value $date_time in concatenation (.) or string a +t D:/upload/Websites/iic2/script/../lib/iic2/Controller/tests/report. +pm line 26. __SNIPPED_A_WHOLE_BUNCH_OF_THESE_THAT_ARE_ALL_THE_SAME_AND_RELATE_TO_T +HE_MISSING_DATE Use of uninitialized value $date_time in concatenation (.) or string a +t D:/upload/Websites/iic2/script/../lib/iic2/Controller/tests/report. +pm line 26. [info] *** Request 1292 (0.005/s) [6088] [Mon Jun 29 11:54:59 2009] ** +* [debug] "GET" request for "tests/report/day_simple/ART_CRV/2009-06-24" + from "127 .0.0.1" [debug] Path is "tests/report/day_simple" [debug] Arguments are "ART_CRV/2009-06-24" [info] Request took 0.151744s (6.590/s) .------------------------------------------------------------+-------- +---. | Action | Time + | +------------------------------------------------------------+-------- +---+ | /tests/report/day_simple | 0.12781 +2s | | /end | 0.00176 +9s | '------------------------------------------------------------+-------- +---'

Replies are listed 'Best First'.
Re^4: DBIC intermittently returning rows missing date_time value
by Corion (Patriarch) on Jun 29, 2009 at 11:04 UTC

    Nowhere in your posted code is a variable with name $date_time shown, yet Perl reports a variable with that name as causing the warning. Either Perl made up the variable name on the spot or you didn't show us the code that's causing this (D:/upload/Websites/iic2/lib/iic2/Controller/tests/report.pm).

      Arghh, sorry Corian, I forgot I'd slightly changed the output since the first post. Restoring the code and re-running the trace gives the same output with the exception that the $date_time warning changes to...
      Use of uninitialized value in concatenation (.) or string at D:/upload +/Websites/iic2/script/../lib/iic2/Controller/tests/report.pm line 25.
      Thanks, Rob

        If the value in the date_time column is not null, then the value in the time_taken column is null, which gets turned into undef I guess.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others chanting in the Monastery: (4)
As of 2025-06-17 16:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.