> -----Original Message----- > From: Ulrich Leodolter [mailto:[EMAIL PROTECTED] > Sent: Saturday, February 10, 2007 1:37 PM > To: [email protected] > Subject: [Dbix-class] sql function in left side of where > > hello > > i've read DBIx::C:Manual and SQL::Abstract, but found now > answer how to make a ResultSet search for the following sql query: > > SELECT date FROM my_table WHERE YEAR( date ) = ? >
Here one can find some info on using functions and stored procedures http://search.cpan.org/~jrobinson/DBIx-Class-0.07005/lib/DBIx/Class/Resu ltSet.pm#select HTH, Marc _______________________________________________ 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]/
