Select Code to Download

SELECT * FROM
(
...
    ) AS foo
    
) AS bar

SELECT * FROM
(
...
    ORDER BY f1 DESC
) AS bar
ORDER BY f1 ASC

sub query_database {
    my($self,$dbh,$table_name,$fields,$where,$order)=@_;
...
                                          , $offset
                                          );

my $dbh        = DBI->connect("dbi:ODBC:test", "Martin_Evans", "easyso
+ft", {RaiseError=>1,PrintError=>0});
my $table_name = "bench_char";
...
my @order = qw/f1/;

DBIx::LiveGrid->run( undef, $dbh, $table_name, \@fields, undef, \@orde
+r );