From: Doug Al <douga@...>
Date: 2011-02-25T01:07:38+09:00
Subject: Re: Using CGI params with a MYSQL query

Brian, Thanks for your reply.

I am now getting the value assigned to my variable correctly, however, 
my query is still returning an error.  Not sure what I am missing?

The query is:

result = dbh.query("
        SELECT *
        FROM mytable
        WHERE myfield = ?", myparamvariable
        )

And the error returned is:

in `query': wrong number of arguments(2 for 1) (ArgumentError)
  from ./dp.rb:93:in `<main>'

Thanks for your help.

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