[R] RSQLite query error

2004-10-09 Thread Mikkel Grum
Dear R-helpers, I ran the following little test on RSQLite and got the data below from the query. Unless I've made some mistake, the results of both the where and order by statements have problems: library(RSQLite) con-dbConnect(dbDriver(SQLite),dbname=test) data(USArrests)

Re: [R] RSQLite query error

2004-10-09 Thread David James
Mikkel Grum wrote: Dear R-helpers, I ran the following little test on RSQLite and got the data below from the query. Unless I've made some mistake, the results of both the where and order by statements have problems: This is due to the fact that SQLite as of version 2.8 is typeless and