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.kvindesland at 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 at 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/