The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
From: Sharon Rosner <cico...@gmail.com>
Date: Tue, 06 Nov 2007 01:40:08 -0800
Local: Tues, Nov 6 2007 4:40 am
Subject: Re: help with aggregation & group by
> from :c => Customer, :b => Bank, :a => Account Actually for that kind of thing you can specify your filter as a hash: > select b.name > where ((c.firstname == first1) | > (c.firstname == first2)), etc. > appeared simpler than having blocks and .AS, but no doubt there is a where(:firstname => [first1, first2]) Notice how you can provide an array and Sequel takes care of ... WHERE firstname IN ('john', 'george') If you need to qualify the field name you can use the special symbol where(:c__firstname => [first1, first2]) Sequel also lets you use any comparison operator, not just ==: where {:price > 100} You can also specify mathemtic expressions and compare against other where {:price < :avg[:price] - 100} Have a look at the cheat sheet: http://code.google.com/p/ruby-sequel/wiki/CheatSheet sharon You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| ||||||||||||||