I've come to the conclusion that the DISTINCT doesn't work with GT::SQL::Condition because it is not part of the WHERE clause. It needs to be used with the regular select clause as in -
my $sth = $table->select ('DISTINCT fieldname');
Is this correct??
Thanks
Simon.
To see DISTINCT incorporated with a seperate GT::SQL::Condition (WHERE clause) take a look at http://gossamer-threads.com/...orum.cgi?post=232703
my $sth = $table->select ('DISTINCT fieldname');
Is this correct??
Thanks
Simon.
To see DISTINCT incorporated with a seperate GT::SQL::Condition (WHERE clause) take a look at http://gossamer-threads.com/...orum.cgi?post=232703