[R] sql query variable

RagingJim nowa0021 at flinders.edu.au
Wed Feb 17 03:21:19 CET 2010


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?

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



More information about the R-help mailing list