Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Click_track bug?

Dec 14, 2000, 10:27 PM
pugdog
Veteran / Moderator (6956 posts)
Dec 14, 2000, 10:27 PM
Post #1 of 2
Views: 1663
Shortcut
Quote Reply
Click_track bug?
Alex,

I'm rewriting the rating script to track ratings, and I noticed you do:

Code:
## Remove old rate tracks.
Links::init_date();
my $delete_by = GT::Date::date_get ( time() - 172800 ); # 2 days old
my $click_db = $DB->table ('ClickTrack');
$click_db->delete ( GT::SQL::Condition->new ( 'Created', '<', $delete_by ));
.

Shouldn't that really be qualified

"WHERE ClickType = 'Rate'"


??

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ


Dec 15, 2000, 9:30 AM
Alex
Administrator (9387 posts)
Dec 15, 2000, 9:30 AM
Post #2 of 2
Views: 1596
Shortcut
Quote Reply
Re: Click_track bug? In reply to
Hi,

Yes, you are right! It should be:

$click_db->delete ( GT::SQL::Condition->new ( 'Created', '<', $delete_by, 'ClickType', '=', 'Rate' ));

=)

Cheers,

Alex

--
Gossamer Threads Inc.