Octavian Rasnita wrote: > Hi all, > > I have tried to use the same column for more times in the condition part > of the query, but it is used only once. > > I want to do something like: > > select count(*) from table_name where date>=? and date<=?; > > Can you also tell me how to use > > and date between ? and ? > > Or even better, please tell me in which of the POD docs to search for > details about these. > I have searched in more POD docs after some keywords, but I couldn't > find anything. > > Thank you. > > Octavian
http://search.cpan.org/~jrobinson/DBIx-Class-0.07999_02/lib/DBIx/Class/ResultSet.pm#search > my $new_rs = $cd_rs->search([ { year => 2005 }, { year => 2004 } ]); > # year = 2005 OR year = 2004
signature.asc
Description: OpenPGP digital signature
_______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
