Re: [RDBO] using functions

On 4/14/07 1:16 AM, Jonathan Vanasco wrote: > is there a way to get Rose to search based on functions? > > ie: > bad > SELECT * FROM useraccount WHERE email = ? > good > SELECT * FROM useraccount WHERE lower(email) = lower(?) See this thread for some earlier discussion on this topic: http://www.

Re: [RDBO] Status of Aggregates?

On 4/13/07 11:08 PM, Bill Moseley wrote: > On Fri, Apr 13, 2007 at 07:40:04PM -0700, Bill Moseley wrote: >> This is still the current situation?: >> >> http://www.dev411.com/blog/2006/05/31/rose-db-object-aggregates >> >> i.e. Run you own SQL directly with DBI or use Views and a create a >> t

Re: [RDBO] using functions

On Apr 15, 2007, at 3:50 PM, John Siracusa wrote: > On 4/14/07 1:16 AM, Jonathan Vanasco wrote: >> is there a way to get Rose to search based on functions? >> >> ie: >> bad >> SELECT * FROM useraccount WHERE email = ? >> good >> SELECT * FROM useraccount WHERE lower(email) = lower(?) > > See this