Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [jai] SELECT DISTINCT

Quote Reply
Re: [jai] SELECT DISTINCT In reply to
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.
Subject Author Views Date
Thread SELECT DISTINCT jai 4889 Feb 9, 2003, 8:58 PM
Thread Re: [jai] SELECT DISTINCT
jai 4788 Feb 11, 2003, 1:28 AM
Thread Re: [jai] SELECT DISTINCT
Paul 4809 Feb 11, 2003, 2:16 AM
Thread Re: [Paul] SELECT DISTINCT
jai 4742 Feb 11, 2003, 3:44 PM
Thread Re: [jai] SELECT DISTINCT
Paul 4747 Feb 11, 2003, 3:53 PM
Thread Re: [Paul] SELECT DISTINCT
jai 4763 Feb 11, 2003, 8:18 PM
Thread Re: [jai] SELECT DISTINCT
jai 4709 Feb 14, 2003, 5:41 AM
Post Re: [jai] SELECT DISTINCT
Paul 4754 Feb 14, 2003, 5:51 AM