Hey guys... Long time... Hope all is well with all the old timers... :)
Quick question for you... Is anything like this possible with the GT module?
$sql_db->select_options ("ORDER BY col_a+col_b DESC");
my $sth = $sql_db->select ( { col_a+col_b > $x && col_a+col_b < $y });
I'm try to select a range of records, greater than $x but less than $y. Clearly this can be done with perl, however I'd much rather let mysql zip through it....
Addition in the ORDER BY statement seems to work fine... I just can for the life me find the answer already in the code somewhere or via Google...
Thanks for your suggestions/help...
AlexJ
Quick question for you... Is anything like this possible with the GT module?
$sql_db->select_options ("ORDER BY col_a+col_b DESC");
my $sth = $sql_db->select ( { col_a+col_b > $x && col_a+col_b < $y });
I'm try to select a range of records, greater than $x but less than $y. Clearly this can be done with perl, however I'd much rather let mysql zip through it....
Addition in the ORDER BY statement seems to work fine... I just can for the life me find the answer already in the code somewhere or via Google...
Thanks for your suggestions/help...
AlexJ