From: Justin To <tekmc@...>
Date: 2008-07-02T06:42:03+09:00
Subject: Ruby MySQL INSERT variable

k = "50"

my = Mysql::new("localhost", "root", "pass", "table")
my.query("INSERT INTO table VALUES('2008-05', #{k}, 324)")

./Class.rb:212:in `query': Unknown column '50' in 'field list'
(Mysql::Error)

How do I insert a variable into a row?

Thanks
-- 
Posted via http://www.ruby-forum.com/.