Re^4: DBIC intermittently returning rows missing date

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).

Comment on Re^4: DBIC intermittently returning rows missing date_time value Select or Download Code

Replies are listed 'Best First'.
Re^5: DBIC intermittently returning rows missing date_time value by reasonablekeith (Deacon) on Jun 29, 2009 at 11:17 UTC
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.` [download] Thanks, Rob	[reply] [d/l]
Re^6: DBIC intermittently returning rows missing date_time value by Corion (Patriarch) on Jun 29, 2009 at 11:41 UTC
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.	[reply] [d/l] [select]
Re^7: DBIC intermittently returning rows missing date_time value by reasonablekeith (Deacon) on Jun 29, 2009 at 12:44 UTC
No, time_taken is always fine, date_time is not coming back from the get_column request, even though it's there. The report is selected and ordered by date_time, so if the date_time value was actually null it wouldn't be in the result set, or they'd all be at the end or the beginning, rather than what I'm seeing, which is the occasional row failing to populate date_time in the results.	[reply]
Re^8: DBIC intermittently returning rows missing date_time value by Corion (Patriarch) on Jun 29, 2009 at 13:22 UTC
Re^9: DBIC intermittently returning rows missing date_time value by reasonablekeith (Deacon) on Jun 29, 2009 at 14:23 UTC


Problems? Is your data what you think it is?
	PerlMonks

Re^4: DBIC intermittently returning rows missing date_time value