(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Help on COUNT DISTINCT: Edit Log

Here is the list of edits for this post
Mar 6, 2007, 5:38 PM
SaraBem
Novice (27 posts)
Mar 6, 2007, 5:38 PM
Views: 2674
Help on COUNT DISTINCT
Hi, can someone point me the right sintax fo use in LinksSQL for the following?

select COUNT(DISTINCT LinkOwner) from Links

What I want is this:

User with listings:<%total_owners%>
using
Code:
sub {
my $total = $DB->table('Links')->count ( ['DISTINCT(LinkOwner)'] );
return $total;
}
but doesn't work...

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Blondies can have brains (sometimes...)

Last edited by:

SaraBem: Mar 6, 2007, 6:10 PM

Edit Log: