Pass numeric variable to a sql statement in R

Question

I can't pass my variable Q1 in a SQL query in R: code:

Q1=23
sqlStatement <- paste("SELECT long,lat FROM "Interpolation" where var1>",Q1,'"',sep=""))

inter1<-dbGetQuery(con, sqlStatement;)

Erreur:

Error: unexpected symbol in "sqlStatement <- paste("SELECT long,lat FROM "Interpolation"

Can someone help me please !

Ps:I tried a lot of suggestions that I found on the forum but nothing works -How to use a variable name in a SQL statement? -Pass R variable to a sql statement

Yorgos · Accepted Answer · 2014-10-20 14:16:37Z

1

Try this one

paste("SELECT long,lat FROM 'Interpolation' where var1>",Q1,sep="")

or

paste("SELECT long,lat FROM Interpolation where var1>",Q1,sep="")

answered Oct 20, 2014 at 14:16

Yorgos

30.6k20 gold badges114 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user26480 Over a year ago

@ George Dontas :Thanks a lot for the help it works, there was also a confused between " and ' -----> sqlStatement <- paste('SELECT long,lat FROM "Interpolation" where var1>',Q1,sep="")

user26480 Over a year ago

@♦George Dontas :if they are two conditions Q1 et Q2 , what is the syntax?

Yorgos Over a year ago

paste("SELECT long,lat FROM Interpolation where var1>",Q1," and var2>",Q2,sep="")

Collectives™ on Stack Overflow

Pass numeric variable to a sql statement in R

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related