search for: sunduration

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

2009 May 25
3
Interpolating variables within (RODBC library) SQL statements for MySQL
...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 YPOS, XP...