search for: ntemp

...ould look something like: Map: ID: 1, 2, 3, 4,... IDrec: 1, 2, 3, 4,... IDrec1: A, B, C, D,... IDdes: 2, 3, 1, 5,.... IDdes1: B, C, A, E,... So I copy in the first set of values easily: dbGetQuery(db, "INSERT INTO Map(ID, IDrec, IDrec1, IDdes1) SELECT ID, ID, IDrec, IDdes FROM Ntemp") Giving me a table that looks like: Map: ID: 1, 2, 3, 4,... IDrec: 1, 2, 3, 4,... IDrec1: A, B, C, D,... IDdes: NA,NA,NA,NA,... IDdes1: B, C, A, E,... Then I create a new table with just the IDdes values I need: dbGetQuery(db, "Create table temp2 as SELECT temp.ID...

...ear R-helpers, I have been using \n in my plot titles to split long titles into two lines. I recently tried combining \n and plotmath which still gives me two lines for the title but also a weird blank spacing. A simple example is as follows: plot(1:10, main=expression(paste("Exposure\nTemp (", degree*F, ")"))) Is there something I'm missing to close the spacing. I have searched the R-help archives to no avail. I am using R-2.3.0 with Windows XP. Thank you in advance for any help. D. Arenas __________________________________________________ [[alternativ...

...ould look something like: Map: ID: 1, 2, 3, 4,... IDrec: 1, 2, 3, 4,... IDrec1: A, B, C, D,... IDdes: 2, 3, 1, 5,.... IDdes1: B, C, A, E,... So I copy in the first set of values easily: dbGetQuery(db, "INSERT INTO Map(ID, IDrec, IDrec1, IDdes1) SELECT ID, ID, IDrec, IDdes FROM Ntemp") Giving me a table that looks like: Map: ID: 1, 2, 3, 4,... IDrec: 1, 2, 3, 4,... IDrec1: A, B, C, D,... IDdes: NA,NA,NA,NA,... IDdes1: B, C, A, E,... Then I create a new table with just the IDdes values I need: dbGetQuery(db, "Create table temp2 as SELECT temp.ID...