Displaying 1 result from an estimated 1 matches for "dbo_sampl".
Did you mean:
dbo_sample
2006 Feb 09
0
quote problem
...nd a value. I want to put everything in a list such that for each sampling point (say OS1) I have two columns (date, time). I use the function sqlQuery from the RODBC package.
Here is an example that works:
OxygenMeasurements$OS1 <- sqlQuery(channel, "SELECT saDateTime, sdValue FROM dbo_Sample WHERE (paID = 213) AND (stCode ='OS1');")
To keep the code "elegant" and, above all, short I try to regenerate the same
function call with a different query statement for each sampling point by using
the paste() function.
(1) sqlquery <- paste("SELEC...