Excellent, thanks. This solved it.
ottar On 22 June 2010 11:39, Hadley Wickham <had...@rice.edu> wrote: > Hi Ottar, > > It's a bug in the code that automatically figures out the axis ticks. > I have some code to fix it, but it's waiting for a release of another > package. In the meantime, you can work around it by specifying where > you want the breaks: > > ggplot(data, aes(time, PU) ) + > geom_line() + > scale_x_datetime(major = "3 hours") > > Hadley > > PS. You can make the code completely reproducible with (e.g.) > load(url("http://master.kvindesland.no/R/failed_data.Rdata")) > > On Mon, Jun 21, 2010 at 3:24 PM, Ottar Kvindesland > <ottar.kvindesl...@gmail.com> wrote: > > 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 <had...@rice.edu> 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 > >> <ottar.kvindesl...@gmail.com> 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]] > >> > > >> > ______________________________________________ > >> > R-help@r-project.org 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/ > > > > > > > > -- > Assistant Professor / Dobelman Family Junior Chair > Department of Statistics / Rice University > http://had.co.nz/ > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org 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.