[R] sql query variable

[Dieter Menne]

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
paste()

Dieter

-- 
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.