commit ddbaf5b9ea92a39fc1dda896708009da12cd0af5 Author: Karsten Loesing <karsten.loesing@gmx.net> Date: Fri Jul 29 07:33:26 2011 -0400 Fix missing comma in #3338 R script. --- task-3338/daily-users.R | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/task-3338/daily-users.R b/task-3338/daily-users.R index 58921cc..dc3583f 100644 --- a/task-3338/daily-users.R +++ b/task-3338/daily-users.R @@ -14,7 +14,7 @@ dbpassword= "password" ###### <- put in real password here! plot_dirbytes <- function(start, end, path, dpi) { drv <- dbDriver("PostgreSQL") con <- dbConnect(drv, user = dbuser, password = dbpassword, dbname = db) - q <- paste("SELECT date, r, bwp, brp, bwn, brn, bwr, brr " + q <- paste("SELECT date, r, bwp, brp, bwn, brn, bwr, brr ", "FROM user_stats WHERE date >= '", start, "' AND date <= '", end, "' AND date < (SELECT MAX(date) FROM user_stats) - 1 ", "AND country = 'zy' ORDER BY date", sep = "")