Hi,
I'm not sure about this but try changing this:
my $table = $DB->table('Category');
my $sth=$table->select({'FatherID' => $catid},['Full_Name','Name']);
to this:
my $table = $DB->table('Category');
$table->select_options ('ORDER BY Name');
my $sth=$table->select({'FatherID' => $catid},['Full_Name','Name']);
(untested)
--
Matt G
I'm not sure about this but try changing this:
my $table = $DB->table('Category');
my $sth=$table->select({'FatherID' => $catid},['Full_Name','Name']);
to this:
my $table = $DB->table('Category');
$table->select_options ('ORDER BY Name');
my $sth=$table->select({'FatherID' => $catid},['Full_Name','Name']);
(untested)
--
Matt G