[Dbix-class] Removing quote chars from HAVING terms?

[Chris Burch]

Hello,

Because I have to use MS SQL Server, in my connect_info I set quote_char => [qw/[ ]/ and name_sep => '.'

However, the quote characters go around things they shouldn't. E.g.

      having => { 'count(me.[sectionid])' => { '=', $section_ct } },

becomes in SQL

 HAVING [count(me.[sectionid])] = ?

which is incorrect.

Is there a way around this? I tried \'count(me.[sectionid])' , analogous to passing a scalar ref to order_by, but having doesn't dereference it.

Thanks in advance,
Chris


Chris Burch
Data Analyst/Web Programmer
Planning/Research & Evaluation
Madison Metropolitan School District
(608) 663-1916
cburch at madison.k12.wi.us