DBI question: binding params in HAVING clauses
andy at hexten.net
Fri Jan 27 14:25:38 GMT 2006
On 27 Jan 2006, at 13:58, David Cantrell wrote:
> Indeed. However, because of how I'm building my queries, I don't know
> in advance which params are going to be strings and which are
> ints. So
> now I'm having to do ...
> $val = $dbh->quote($val) if($val !~/^-?\d+(\.\d+)?$/);
> and things are beginning to look really messy. Not to mention that I
> got the regex wrong twice. Which gets me back to wanting
Why can't you just wrap the quoting up in a subroutine? It shouldn't
be duplicated surely?
Andy Armstrong, hexten.net
More information about the london.pm