On Apr 9, 12:26 pm, mwlang88 <[email protected]> wrote: > MySql Adapter on Sequel 3.9.0: > > According to Virtual Row Documentation: > > http://sequel.rubyforge.org/rdoc/classes/Sequel/SQL/VirtualRow.html > > You count distinct with: > ds.select{count(:distinct, col1){}} # SELECT count(DISTINCT col1) FROM > t > > When I use it: > > ds.select{[:p__ref_physician_code, > count(:distinct, :p__chart_number).as(:cases)]} > > I get: > > `p`.`ref_physician_code`, count( `distinct` , `p`.`chart_number` ) AS > `cases` > > What am I doing wrong?
You aren't providing a block to the count method. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
