search for: sundur

...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 <- sqlQuery(channel, "select YPO...