From: "Bartosz Dziewoński" <matma.rex@...>
Date: 2012-02-08T04:09:10+09:00
Subject: Re: MySQL access, parameter binding

I can't tell about the first question, but for second you can use the
splat operator.


> bindParams = [ 1, 2 ]
> sth = dbh.prepare( "select * from table where a = ? and b = ? " )
> sth.execute( bindParams )

> sth.execute( bindParams[0], bindParams[1] )

Use this: sth.execute(*bindParams). The star (called "splat" in this
context) will "split" the array into individual components, and pass
all of them as arguments to the method. You can use the same operator
for example for "destructuring assignment":

a, b = * 'some text'.split(/ /)
#=> a = 'some', b = 'text'

-- Matma Rex