Displaying 1 result from an estimated 1 matches for "record_datetim".
Did you mean:
record_datetime
2010 Jun 10
1
Can RMySQL be used for a paramterized query?
...er_table WHERE t1_id = x" where 'x' is
one of the IDs returned by the first select statement. Actually, I have to
do this in two contexts, one where the data are not ordered by time and one
where it is (and thus where I'd have to use TSMySQL to execute something
like "SELECT record_datetime,value FROM my_ts_table WHERE t2_id = x").
I'd like to embed this in a loop where I iterate over the IDs returned by
the first select, get the appropriate data from the second for each ID,
analyze that data and store results in another table in the DB, and then
proceed to the next ID in t...