From: David Jacobs <davidbe@...>
Date: 2005-05-27T23:10:12+09:00
Subject: dbi: passing parameters to execute

Hi,

I'm fairly new to Ruby. I touched some Perl, looked at Python, but the
elegance and clarity of the code in the doc's/tutorials of Ruby
attracted me (I'm no expert-programmer at all so this is very
subjective!).

I can declare some parameters in a SQL-statement with ?-marks and I
can pass the appropriate value(s) with the method execute(). This is
easy when the sql-code is like
***
select *
from bla
where
year = ?
***

How do I pass values when my sql-code is something like
***
select *
from bla
where
year IN ?
***

Is this possible? Do I have to pass an array of integers? (I guess not
because it doesn't work...) I've been googling alot to find any help,
in vain -- I'm clueless.

Many thanks in advance!
Kind regards,
David