On Fri, 22 Dec 2006, Moritz Onken wrote:
Hi,
i want to use a statement with the MD5-function in the where clause.
Like
SELECT * from table where password = MD5('secret')
->search({ -and => \'password = MD5(?)'}, { bind => ['secret'] });
or substitute "me.fieldname" to use a field instead of a value, and drop
the bind.
DBIx::Class::Manual:: Cookbook had no answer on that.
Yup, it probably should have.. would also be nice if the where handled it
like select does.. e.g. password => { MD5 => 'secret'} ..
Jess
_______________________________________________
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]/
