[Dbix-class] binding variables to CASE WHEN

Adam Witney awitney at sgul.ac.uk
Wed Apr 8 11:39:13 GMT 2015


> This will do what you want safely, using bind parameters:
> 
>     { count => \["CASE WHEN pathogen.name = ? THEN 1 ELSE NULL END",
> $name1] },

Thanks, this works perfectly


More information about the DBIx-Class mailing list