Blog
Developers
Careers
Support
Contact
Gossamer Threads
Solutions
Results
About
Mailing Lists
Resource Centre
Forum
Tools
Home
Who's Online
Tags
Favourites
Login
Forum Search
(
Advanced Search
)
This forum
This category
All forums
for
Home
:
Products
:
Gossamer Links
:
Discussions
:
Links needing change
Previous Thread
Next Thread
Print Thread
View Threaded
Sep 27, 2006, 8:14 AM
rascal
User
(346 posts)
Sep 27, 2006, 8:14 AM
Post #1 of 9
Views: 3960
Shortcut
Links needing change
Hi,
Anyone have global for counting modified links that need to be validated?
Thanks in advance
Sep 27, 2006, 3:24 PM
jdgamble
Enthusiast
(700 posts)
Sep 27, 2006, 3:24 PM
Post #2 of 9
Views: 3918
Shortcut
Re: [rascal] Links needing change
In reply to
You just need to count the Changes table like so:
Code:
sub {
return $DB->table('Changes')->select('COUNT(*)');
}
- Jonathan
Sep 27, 2006, 9:01 PM
fuzzy logic
Enthusiast
(854 posts)
Sep 27, 2006, 9:01 PM
Post #3 of 9
Views: 3886
Shortcut
Re: [jdgamble] Links needing change
In reply to
or (shorthand):
Code:
sub {
return $DB->table('Changes')->count();
}
Philip
------------------
Limecat is not pleased.
Sep 27, 2006, 9:08 PM
rascal
User
(346 posts)
Sep 27, 2006, 9:08 PM
Post #4 of 9
Views: 3883
Shortcut
Re: [fuzzy logic] Links needing change
In reply to
Thank you both!
Could I just have it for the linkowner?
Sep 27, 2006, 11:10 PM
fuzzy logic
Enthusiast
(854 posts)
Sep 27, 2006, 11:10 PM
Post #5 of 9
Views: 3868
Shortcut
Re: [rascal] Links needing change
In reply to
Code:
sub {
my $user = shift;
return $DB->table("Changes")->count({ LinkOwner => $user });
}
might need to have:
Code:
->fetchrow()
Philip
------------------
Limecat is not pleased.
Last
edited
by:
fuzzy logic
: Sep 27, 2006, 11:12 PM
Sep 28, 2006, 8:33 AM
rascal
User
(346 posts)
Sep 28, 2006, 8:33 AM
Post #6 of 9
Views: 3869
Shortcut
Re: [fuzzy logic] Links needing change
In reply to
Tryed neither worked.
sub {
my $user = shift;
return $DB->table("Changes")->count({ LinkOwner => $user });
}
sub {
my $user = shift;
return $DB->table("Changes")->count({ LinkOwner => $user })->fetchrow();
}
Sep 28, 2006, 9:26 AM
fuzzy logic
Enthusiast
(854 posts)
Sep 28, 2006, 9:26 AM
Post #7 of 9
Views: 3867
Shortcut
Re: [rascal] Links needing change
In reply to
in the global call, are you using something like:
<%global($LinkOwner)%>
Philip
------------------
Limecat is not pleased.
Sep 28, 2006, 9:30 AM
fuzzy logic
Enthusiast
(854 posts)
Sep 28, 2006, 9:30 AM
Post #8 of 9
Views: 3857
Shortcut
Re: [fuzzy logic] Links needing change
In reply to
Just checked Changes.def... need to use
count({ Username => $user })
Philip
------------------
Limecat is not pleased.
Sep 28, 2006, 9:40 AM
rascal
User
(346 posts)
Sep 28, 2006, 9:40 AM
Post #9 of 9
Views: 3872
Shortcut
Re: [fuzzy logic] Links needing change
In reply to
Thank you,
It does work, forgot to change Linkowner to Username on display page.
Last
edited
by:
rascal
: Sep 28, 2006, 9:46 AM
Previous Thread
Next Thread
Print Thread
View Threaded