Re: [Dbix-class] Filtering a SELECT based on a calculation of two columns?

On Mon, Feb 21, 2011 at 11:22, Chris Cole wrote: > On 17/02/11 15:19, Fahad Khan wrote: >> >> This might help: >> >> >> http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Using_SQL_functions_on_the_left_hand_side_of_a_comparison >> >> http://search.cpan.org/~frew/SQL-Abstrac

Re: [Dbix-class] Filtering a SELECT based on a calculation of two columns?

On 21 Feb 2011, at 16:22, Chris Cole wrote: > On 17/02/11 15:19, Fahad Khan wrote: >> >> This might help: >> >> http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Using_SQL_functions_on_the_left_hand_side_of_a_comparison >> http://search.cpan.org/~frew/SQL-Abstract-1.72/li

Re: [Dbix-class] Filtering a SELECT based on a calculation of two columns?

On 17/02/11 15:19, Fahad Khan wrote: This might help: http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Using_SQL_functions_on_the_left_hand_side_of_a_comparison http://search.cpan.org/~frew/SQL-Abstract-1.72/lib/SQL/Abstract.pm#Literal_SQL_with_placeholders_and_bind_val

Re: [Dbix-class] Filtering a SELECT based on a calculation of two columns?

On 17/02/11 15:17, Rob Kinyon wrote: On Thu, Feb 17, 2011 at 10:01, Chris Cole wrote: Hi all, I've got a table where two of the columns (say a and b) are simple integers and I want to select rows where b - a< 100. How do I go about that in DBIx. The equivalent SQL would be: SELECT * FROM tab