From: Sebastian probst Eide <sebastian.probst.eide@...>
Date: 2007-05-28T03:04:06+09:00
Subject: Re: Passing DBI parameters as an array

Sorry... I could have though a little bit more myself too before posting 
to the forum.
I just have to expand the array:

DBI.connect("DBI:Mysql:#{DB_DATABASE}:#{DB_SERVER}", DB_USER,
DB_PASSWORD) do |dbh|
  value1 = "Something"
  value2 = "Something"
  value3 = "Something"
  array_in = [value1, value2, value3]
  sql_insert = "INSERT INTO users (email) VALUES (?), (?), (?)"

  #This is what I need to work
  dbh.do(sql_insert, *array_in)
end

and then it works!

never mind!

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