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. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.