Eric Wee wrote: > Hi there, > > > > I’m trying to construct the following “where” clause in DBIx but not > sure how to do so. > > > > WHERE > > is_retail = '1' > > AND enabled_date is not null > > AND enabled_date < now() > > AND (disabled_date is null > > OR disabled_date < enabled_date > > OR disabled_date > now()) > > >
Show us what you've tried so far. _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
