Sorry, I just wrote that as an example. What I actually did was write the fieldname (no $column) but it still doesn't work.
my $sth = $table->select ( GT::SQL::Condition->new ('DISTINCT fieldname','LIKE',"$letter%") );
Anyway, just to simplify my question -
Why does this work -
my $sth = $table->select ('DISTINCT fieldname');
but this doesn't -
my $sth = $table->select ( GT::SQL::Condition->new ('DISTINCT fieldname') );
Thanks
Simon.
my $sth = $table->select ( GT::SQL::Condition->new ('DISTINCT fieldname','LIKE',"$letter%") );
Anyway, just to simplify my question -
Why does this work -
my $sth = $table->select ('DISTINCT fieldname');
but this doesn't -
my $sth = $table->select ( GT::SQL::Condition->new ('DISTINCT fieldname') );
Thanks
Simon.