Unable to pass strings in dbgetquery in r. it says invalid identifier

user_15127511 0
Viewed 35

When i run this, it says its invalid identifier "RTX" .

 gf<-"cyberpunk"
 #input$rat gives a value of string "RTX"
delete<-paste("select * from games where name = ",gf," and graphics = ",input$rat, sep="")
      
      yx<-dbGetQuery(ValidateUser,delete)
      print(yx)
r sqlite sql
2 Answers

You need to include quotes in the query for all character fields, and paste0 instead of paste will avoid unexpected spaces :

delete <- paste0("select * from games where name = '",gf,"' and graphics = '",input$rat,"'")

delete
[1] "select * from games where name = 'cyberpunk' and graphics = 'RTX'"
user_135133280

We may use glue

glue::glue("select * from games where name = '{gf}' and graphics = '{input$rat}'")
user_37322710
Related