Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [Paul] SELECT DISTINCT

Quote Reply
Re: [Paul] SELECT DISTINCT In reply to
Paul,

Thanks for your reply but it didn't make any difference.

I just can't get it to work with the GT::SQL::Condition->new.

I can get it to work using -

my $sth = $table->select ('DISTINCT $column','LIKE',"$letter%");

but not with -

my $sth = $table->select ( GT::SQL::Condition->new ('DISTINCT $column','LIKE',"$letter%") );

I guess I'll just go with the one that works but I would still like to know why the other doesn't work if anyone has 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 4787 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