SELECT * FROM
(
SELECT TOP 10 * FROM
(
SELECT TOP 30 f1, f2 FROM bench_char
) AS foo
) AS bar
####
SELECT * FROM
(
SELECT TOP 10 * FROM
(
SELECT TOP 30 f1, f2 FROM bench_char ORDER BY f1 ASC
) AS foo
ORDER BY f1 DESC
) AS bar
ORDER BY f1 ASC
##
##
sub query_database {
my($self,$dbh,$table_name,$fields,$where,$order)=@_;
my $rows = $self->get('ajax_page_size');
my $offset = $self->get('ajax_offset');
my $sort_dir = $self->get('ajax_sort_dir');
my $sort_col = $self->get('ajax_sort_col');
$sort_col = $self->clean_param('sort_col',$sort_col);
my @porder = ();
if ($sort_col) {
@porder = ("$sort_col $sort_dir");
$order = \@porder;
}
require SQL::Abstract::Limit;
my $abstract = SQL::Abstract::Limit->new( limit_dialect => $dbh );
my( $stmt, @bind ) = $abstract->select( $table_name
, $fields
, $where
, $order
, $rows
, $offset
);
##
##
my $dbh = DBI->connect("dbi:ODBC:test", "Martin_Evans", "easysoft", {RaiseError=>1,PrintError=>0});
my $table_name = "bench_char";
my @fields = qw/f1 f2/;
my @order = qw/f1/;
DBIx::LiveGrid->run( undef, $dbh, $table_name, \@fields, undef, \@order );