DBI question: binding params in HAVING clauses

Andy Armstrong andy at hexten.net
Thu Jan 26 16:27:34 GMT 2006

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'");


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

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

More information about the london.pm mailing list