R help - Feb 2010 - sql query variable

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.

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.

Another way:

cat("Station number?")
flush.console()
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=""))

Bart

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

Thanks guys. I ended up doing as you suggested Dieter. Thanks for the idea :)
-- 
View this message in context:
http://n4.nabble.com/sql-query-variable-tp1558189p1561158.html
Sent from the R help mailing list archive at Nabble.com.