[R] sql query variable

Bart Joosen bartjoosen at hotmail.com
Wed Feb 17 12:06:20 CET 2010

Another way:

cat("Station number?")
sn <- scan(quiet=TRUE,n=1)
sqlQuery(conn, paste("select to_char(lsd,'yyyy-mm') as yr,ttl_mo_prcp from
mo_rains where stn_num=",sn,sep=""))


View this message in context: http://n4.nabble.com/sql-query-variable-tp1558189p1558504.html
Sent from the R help mailing list archive at Nabble.com.

More information about the R-help mailing list