Archive for

Mixing quoted and non quoted values with Ruby DBI prepared statements

Sorry for the somewhat long title, but I messed a bit with DBI in Ruby today, and I had some problems with prepared statements, as DBI quotes everything. I wanted to do something like the following: sth = dbh.prepare(“UPDATE table SET ? = ? WHERE id = ‘1’”) With a normal approach, both values would … Continue reading →