Hi Simon,

Sorry for late reply on this post.

You could use rs option in CGI input to force a select_returns (fields that you wish returned) from using query_sth function:


$self->{db}->select_options("GROUP BY public_holiday_201, public_holiday_owner_id");
$self->{cgi}->{rs} = 'public_holiday_201,public_holiday_owner_id';
# Do the search and count the results.
my $sth = $self->{db}->query_sth ($self->{cgi}) or return $self->modify_search_form($GT::SQL::error);


Hope that helps,
Jean
Gossamer Threads Inc.