Re: Trouble making set_sql work...

[prev] [thread] [next] [Date index for 2004/07/13]

From: Jesse Sheidlower
Subject: Re: Trouble making set_sql work...
Date: 15:04 on 13 Jul 2004

On Tue, Jul 13, 2004 at 10:58:00AM -0400, Andy Harrison wrote:
> 
> Now the error message is something else entirely:
> 
> ::opt_top::>senders<:: 
> ::opt_top_limit::>10<::
> Maillog::Report::top_statsMaillog::Report::top_stats can't  
>                                     SELECT option_data, COUNT(*) 
>                                     FROM entry_options 
>                                     WHERE option = '?' 
>                                     GROUP BY option_data 
>                                     ORDER BY count DESC
>                                     LIMIT ?;
>                                    : execute called with 2 bind
> variables, 1 needed at

[...]

> Am I using the ? symbols incorrectly?

I think you're using the ' symbol incorrectly--I've forgotten 
the exact form of your original query but if you're single-quoting
the ? in the "WHERE option =" line, then it's a question mark,
not a placeholder. Try removing the single quotes.

Jesse Sheidlower