hello

when I search links in my admin & select a subcategory to search with it works normal.
But when i specify something like Order by ID Descending, it still display the results ascending.

what should i do to get this work?

hello

I see that the category list will be generated from Links::Link.pm and the rest of the search function is a part of GT::SQL::Admin.pm

I have an image attached, in which you can see what i mean.

who have this problem too, and what's the best way to solve?

is this an issue of MySQL or does this problem exists with other databases (PostGres, MSQL, Oracle)?

I've tested various indexing schemes (MYSQL, NONINDEXED, INTERNAL)

I found this problem a couple of weeks ago, and I've tried the following with success.

in line 60

change:


$self->select_options ("ORDER BY $in->{sb} $in->{so}") if ($in->{sb});
$self->select_options ("LIMIT $offset, $in->{mh}") unless ($in->{mh} == -1);

in:

$db->select_options ("ORDER BY $in->{sb} $in->{so}") if ($in->{sb});
$db->select_options ("LIMIT $offset, $in->{mh}") unless ($in->{mh} == -1);


and it works, because it use now the CatLinks','Links
table defined in line 49 and not the Links table only.

hope it helps.

I can't see a difference in your two code snippets?

There is:
$db->select_options ("LIMIT $offset, $in->{mh}") unless ($in->{mh} == -1);

Best regards,
Webmaster33

---

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

Thanks, I've fixed this up in the source.

Cheers,

Alex
--
Gossamer Threads Inc.