As some know, I screwed up the entry form for the June Bets. (Specifically, I cut and pasted the April entry form and failed to change the ‘DateMetric’ field to “June,2014). Luckily, a visitor noticed the problem and I changed the DateMetric field. For this reason, all early bets were “invisible” (though still in the database.) I ran the SQL update command <\/p>\n
UPDATE `data_base_tname`.`table_name` SET `DateMetric` = ‘June, 2014’ WHERE `Date_Submitted` > ‘2014-06-16’<\/p>\n
June Bets should be updated with all bets previously noted as “April” (but placed after Jun 16) should now be categorized as June. Those who wish to proof read, please let me know if you found errors here:
\n[sockulator(..\/musings\/wp-content\/uploads\/2011\/UAHBets5.php?Metric=UAH TTL?Units=C?cutOffMonth=6?cutOffDay=25?cutOffYear=2014?DateMetric=June, 2014?)sockulator]<\/p>\n
(I did see other questions in comments– but I think it’s best to let you look at the current output before hunting for individual issues which likely were corrected by this single command.)<\/p>\n","protected":false},"excerpt":{"rendered":"
As some know, I screwed up the entry form for the June Bets. (Specifically, I cut and pasted the April entry form and failed to change the ‘DateMetric’ field to “June,2014). Luckily, a visitor noticed the problem and I changed the DateMetric field. For this reason, all early bets were “invisible” (though still in the … Continue reading June Bets!<\/span>