http://www.perlmonks.org?node_id=649002


in reply to DBI:CSV SQL parsing problem

Any idea what is going wrong?
I'd say it's apparent that the SQL expression parser employed by DBD::CSV is unable to deal with such a complicated expression (either at all, or with the amount of type information at its disposal). Specifically, the parser expects a variable or a numeric literal as the argument to an aggregate function.

Assuming that's not the case, have you tried more parentheses ? some form of value coercion ?

-David

Replies are listed 'Best First'.
Re^2: DBI:CSV SQL parsing problem
by jZed (Prior) on Nov 05, 2007 at 16:40 UTC
        > Assuming that's not the case, have you tried more parentheses ? 
    
    Or perhaps sprinkling some chicken blood would help :-). The expected behavior is documented in this case so reading the docs is probably quicker (though perhaps not as much fun, depending on your definition of fun) than experimentation.