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
my $total = $DB->table('Links')->count ( ['DISTINCT(LinkOwner)'] );
return $total;
}but doesn't work...
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Blondies can have brains (sometimes...)
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;
}
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Blondies can have brains (sometimes...)
Help on COUNT DISTINCT