Append R variable inside SQLDF's SQL code

Question

Tried to search for an answer using "SQLDF append in code", but I couldnt find any answer.

Basically, I'd like to be able to write something like that :

divisor<-4
result<-sqldf("SELECT id, some_number/ " . divisor . " FROM my_table")

but I can't find a way to have divisor included in the SQL statement : Error: unexpected symbol in "result<-sqldf("SELECT id, some_number/ " ."

I tried having &, + and nothing instead of the dots ., but I can't find anything that works.

I also tried "SELECT id, some_number/divisor FROM my_table", without any " " around divisor, but I get error in statement: no such column: divisor

Thanks.

See example 5 on the sqldf home page: github.com/ggrothendieck/sqldf — G. Grothendieck
– G. Grothendieck, Commented Jan 29, 2016 at 14:11

vmachan · Accepted Answer · 2016-01-28 18:19:01Z

1

You can use

result<-sqldf(sprintf("SELECT id, some_number/%d FROM my_table", divisor))

Hope this helps

answered Jan 28, 2016 at 18:19

vmachan

1,6821 gold badge10 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

Append R variable inside SQLDF's SQL code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related