DBI question: binding params in HAVING clauses
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
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? :-)
Andy Armstrong, hexten.net
More information about the london.pm