I think I can modify the LetterSearch plugin to do a DISTINCT search but I'm not sure how to modify the following line -
my $sth = $table->select ( GT::SQL::Condition->new ($column, 'LIKE', "$letter%") );
How can I change the red part to do a DISTINCT search for $letter in $column.
I've tried all sorts of things like ('DISTINCT', $column, "$letter%"), etc.. but nothing seems to work.
Any ideas?
Thanks
Simon.
my $sth = $table->select ( GT::SQL::Condition->new ($column, 'LIKE', "$letter%") );
How can I change the red part to do a DISTINCT search for $letter in $column.
I've tried all sorts of things like ('DISTINCT', $column, "$letter%"), etc.. but nothing seems to work.
Any ideas?
Thanks
Simon.