DBI question: binding params in HAVING clauses

[Andy Armstrong]

On 26 Jan 2006, at 16:06, David Cantrell wrote:
>> What's the point of $dbh->quote() when %d can only expand to an
>> integer anyway? Or rather what's the point of using sprintf()?
>
> $dbh->quote(3) expands to '3', which then doesn't work in the HAVING
> clause, presumably because it then tries to compare an int to a  
> string.

:)

printf("%d\n", "'3'");

gives

Argument "'3'" isn't numeric in printf at t.pl line 1.
0

so presumably it's because COUNT(actors.name) is never less than zero.

> Do I need to report that as a bug too? :-)

Hell yeah!

-- 
Andy Armstrong, hexten.net