[R] sql query variable

Dieter Menne dieter.menne at menne-biomed.de
Wed Feb 17 08:33:45 CET 2010

RagingJim wrote:
> This is the very last thing I need to make everything work properly. My
> query:
> sqlQuery(conn, "select to_char(lsd,'yyyy-mm') as yr,ttl_mo_prcp from
> mo_rains where stn_num=023000")
> Is there a way to may the stn_num in the query variable, ie make it so
> that whenever my script is run, the user must choose and input the station
> number?

You could use tclTk to input the stn_num, and generate the query string with


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

More information about the R-help mailing list