From: Jeff Bowen <ja_bowen@...>
Date: 2009-07-14T00:12:06+09:00
Subject: MYSQL insert

I'm trying to insert values from a variable into a test MYSQL.  It works
from a fixed value but not if the value is in a variable.

require 'mysql'
$test = "ABC"

#db.query('insert into etf_list values ($test)')
    >> in `query': Column 'test' cannot be null (Mysql::Error)

db.query('insert into etf_list values ("ABC")')
    >> Works

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