Thanks Hadley for taking the interest here. The data sets are a bit large and I have placed them available for your download on
http://master.kvindesland.no/R/ You will find datasets in both Rdata and dput format. It seems that some data sets works nicely and others do not even if they come from a very similar SQL set. The select clause carries more coloumns in the failing data set. ottar On 20 June 2010 18:28, Hadley Wickham <[email protected]> wrote: > Hi Ottar, > > It's impossible to tell what the problem is without a reproducible > example (http://gist.github.com/270442) > > Hadley > > On Sun, Jun 20, 2010 at 4:38 PM, Ottar Kvindesland > <[email protected]> wrote: > > I have a problem that puzzles me a bit today. When loading off data from > a > > database and plotting using ggplot2, I wish to present data as a time > series > > with time of day. The code is text-book like as shown below: > > > > # Fetch data > > con <- dbConnect(dbDriver("MySQL"), user="user", password = "pwd", > > dbname="db") > > data <- dbGetQuery(con, "select PU, DateTime from rep;") > > data$time <- as.POSIXct(data$DateTime) > > attach(data) > > > > # Plot Data > > p <- ggplot(data, aes(x=time, colour=PU ) ) + > > ylim( c(0, max(PU)) ) + > > geom_line( aes(x=time, PU ) ) > > > > p > > > > It starts plotting and terminates before anything is drawn on the canvas. > > The error message on the terminal is: > > > > Error in seq.int(0, to - from, by) : 'to' must be finite > > > > The DateTime coloumn in MySQL is of type datetime Is it a bug or a > feature? > > > > > > > > Thanks > > > > ottar > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > [email protected] mailing list > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. > > > > > > -- > Assistant Professor / Dobelman Family Junior Chair > Department of Statistics / Rice University > http://had.co.nz/ > [[alternative HTML version deleted]] ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
