(Advanced Search)
for
Home : Products : DBMan SQL : Discussion :

Products: DBMan SQL: Discussion: Re: [jai] SELECT DISTINCT: Edit Log

Here is the list of edits for this post
Feb 14, 2003, 5:41 AM
jai
User (417 posts)
Feb 14, 2003, 5:41 AM
Views: 5905
Re: [jai] SELECT DISTINCT
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

Last edited by:

jai: Feb 14, 2003, 5:47 AM

Edit Log: