search for: tempavg

Displaying 1 result from an estimated 1 matches for "tempavg".

2009 May 25
3
Interpolating variables within (RODBC library) SQL statements for MySQL
...the first X-Position So far, so good: SQL Select works and everybody is fine, but this was just the preparation for the next step: Select all data out of the database with e.g. ypos = 1 and xpos = 182... rawdata <- sqlQuery(channel, "select YPOS, XPOS, YEAR, MONTH, RANGE, APFEL, TEMPMIN, TEMPAVG, TEMPMAX, PRECIPITATION, SUNDURATION from DATA where YPOS='ypos' AND XPOS='xpos' AND MONTH BETWEEN 1 AND 12 AND RANGE = 1;") The problem is that I want to use variables (xpos, ypos) to be replaced by the numbers (much more of them) so the SQL String would be: rawdata <- sq...