Displaying 1 result from an estimated 1 matches for "q_valu".
Did you mean:
q_value
2006 Nov 17
2
Forming SQL Query at run-time
...need to use these
indexes in another query, but i keep getting errors.
Here is something:
numb <- dbSendQuery(con2, "select distinct(comparison) from table1")
count <- fetch(numb, -1)
my.matrix <- as.matrix(count)
rs <- dbSendQuery(con2, "select A.comparison,A.id, A.q_value,
B.q_value from table1 as A, table1 as B where A.comparison =
'my.matrix[11481]' AND B.comparison = 250 AND A.id = B.id")
RS-DBI driver: (could not run statement: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax...