Hi,
Sorry about the late reply!
In this case, you should replace the code below (around line #805 within SQL/Table.pm):
$self->select_options ("ORDER BY $in->{sb} $in->{so}") if ($in->{sb});
WITH:
if ( lc $in->{sb} eq 'rand' ) {
$self->select_options ("ORDER BY rand()");
}
elsif ( $in->{db} ) {
$self->select_options ("ORDER BY $in->{sb} $in->{so}");
}
Hope that helps.
TheStone.
Sorry about the late reply!
In this case, you should replace the code below (around line #805 within SQL/Table.pm):
$self->select_options ("ORDER BY $in->{sb} $in->{so}") if ($in->{sb});
WITH:
if ( lc $in->{sb} eq 'rand' ) {
$self->select_options ("ORDER BY rand()");
}
elsif ( $in->{db} ) {
$self->select_options ("ORDER BY $in->{sb} $in->{so}");
}
Hope that helps.
TheStone.