Re: ruby driver postgresql

On Thu, Aug 24, 2006 at 12:11:28PM -0700, Junkone wrote:
> I am using the C driver and am trying to run this statement
> irb(main):020:0> a=conn.exec("select * from exchanges where id=$1",4)
> ArgumentError: wrong number of arguments (2 for 1)
> from (irb):20:in `exec'
> from (irb):20
> from :0
> irb(main):021:0>
>
> I get the error. But the ruby doc stats that i can use this parameteric
> query. any pointers will be useful.

Are you using the ruby-postgres module and looking at the following
documentation or a copy of it?

http://ruby.scripting.ca/postgres/rdoc/

Specifically, is this what you're seeing?

conn.exec(sql, *bind_values)

Sends SQL query request specified by sql to the PostgreSQL.
Returns a PGresult instance on success. On failure, it raises
a PGError exception.

bind_values represents values for the PostgreSQL bind parameters
found in the sql. PostgreSQL bind parameters are presented as $1,
$1, $2, etc.

I just looked through the source code for a few versions of that
module and only the latest snapshot supports multiple arguments for
PGconn#exec. Version 0.7.1 doesn't (that "Release version" is over
3.5 years old!).

--
Michael Fuhr