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

Get Latest Review on Detailed Page

(Page 2 of 2)
> >
Previous ThreadNext ThreadPrint ThreadView Threaded
Jul 8, 2004, 1:40 PM
Alex
Administrator (9387 posts)
Jul 8, 2004, 1:40 PM
Post #26 of 33
Views: 4055
Shortcut
Quote Reply
Re: [sangiro] Get Latest Review on Detailed Page In reply to
Hi,

Quote:
Is there a reason why the <%Num%> tag is not working on the detailed page?

Because Num isn't an actual column, but rather the sum of Review_WasHelpful + Review_WasNotHelpful.

Cheers,

Alex
--
Gossamer Threads Inc.
Jul 8, 2004, 1:41 PM
Alex
Administrator (9387 posts)
Jul 8, 2004, 1:41 PM
Post #27 of 33
Views: 4029
Shortcut
Quote Reply
Re: [SSmeredith] Get Latest Review on Detailed Page In reply to
Hi,

Quote:
I do want to point out that the review will appear before you have validated it.

You should add:

Review_Validated => 'Yes'

to the select claue so you only get validated links.

Cheers,

Alex
--
Gossamer Threads Inc.
Jul 9, 2004, 2:03 AM
sangiro
Enthusiast (524 posts)
sangiro's avatar
Jul 9, 2004, 2:03 AM
Post #28 of 33
Views: 4050
Shortcut
Quote Reply
Re: [Alex] Get Latest Review on Detailed Page In reply to
Ok - I can appreciate that...

I'm trying to do a quick global to calculate this value for my non-review pages. Here's what I have so far but it returns "0". What do I have wrong?

Code:
sub {
my $id = shift;
my ($was,$wasnot)=$DB->table('Reviews')->select({ReviewID=>$id},
['Review_WasHelpful','Review_WasNotHelpful'])->fetchrow_array;
my $total = $was+$wasnot;
return $total;
}

Safe swoops
Sangiro
Jul 9, 2004, 6:17 AM
olivers
User (97 posts)
olivers's avatar
Jul 9, 2004, 6:17 AM
Post #29 of 33
Views: 3997
Shortcut
Quote Reply
Re: [sangiro] Get Latest Review on Detailed Page In reply to
Hi Sangiro

you could also build a sum of the fields within your SQL command. Try something like this:

SELECT ... Review_WasHelpful + Review_WasNotHelpful as Result FROM table ...

I would test the SQL command with a DB server and look at the output - once you know how the output is, you will be able to determine which variable (if you have more than one column) you can use as output of your global. In the sample above, you would see a field "Result" that is the sum of your two other fields.

Hope this helps,
Oliver
Jul 9, 2004, 4:33 PM
afinlr
Veteran (1921 posts)
Jul 9, 2004, 4:33 PM
Post #30 of 33
Views: 4012
Shortcut
Quote Reply
Re: [sangiro] Get Latest Review on Detailed Page In reply to
If you have all the properties of the Review table available as tags couldn't you just use something like
<%set Num=$Review_WasHelpful + $Review_WasNotHelpful%>
(you may need to build this out of a couple of set statements)
Jul 10, 2004, 2:21 AM
sangiro
Enthusiast (524 posts)
sangiro's avatar
Jul 10, 2004, 2:21 AM
Post #31 of 33
Views: 4012
Shortcut
Quote Reply
Re: [afinlr] Get Latest Review on Detailed Page In reply to
Laura,

I tried this initially with no luck. I just tried again and the tag returns nothing (not even 0, but not an error either.) The values for both Was- and WasNotHelpul are definitely available. Not sure why they don't want to add up... Crazy

Safe swoops
Sangiro
Jul 10, 2004, 5:18 AM
afinlr
Veteran (1921 posts)
Jul 10, 2004, 5:18 AM
Post #32 of 33
Views: 4053
Shortcut
Quote Reply
Re: [sangiro] Get Latest Review on Detailed Page In reply to
As I thought, you do have to build it up from a couple of set statements. Try this
<%set Num = $Review_WasHelpful%>
<%set Num += $Review_WasNotHelpful%>
Jul 11, 2004, 4:49 AM
sangiro
Enthusiast (524 posts)
sangiro's avatar
Jul 11, 2004, 4:49 AM
Post #33 of 33
Views: 3958
Shortcut
Quote Reply
Re: [afinlr] Get Latest Review on Detailed Page In reply to
Works like a charm. Thank you. Smile

Safe swoops
Sangiro
> >
Previous ThreadNext ThreadPrint ThreadView Threaded