Gossamer Forum
(Advanced Search)
for
Jan 28, 2008, 3:40 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 28, 2008, 3:40 AM
Views: 5344
Shortcut
Quote Reply
Re: [Andy] ExpiryDate In reply to
BTW, the query is:

Code:
my $sth = $DB->table('Links')->select( GT::SQL::Condition->new('ExpiryDate','>','2147483647') ) || die $GT::SQL::error;

..which gives no results (as I was expecting)

Using:
Code:
my $sth = $DB->table('Links')->select( GT::SQL::Condition->new('ExpiryDate','<','2147483647') ) || die $GT::SQL::error;

..gives ALL of the links in the list Unimpressed

I've even tried:

Code:
'ExpiryDate','>',time


BTW - this is in a pluign, rather than global.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread ExpiryDate Andy 5510 Jan 28, 2008, 3:34 AM
Post Re: [Andy] ExpiryDate 		Andy 5344 Jan 28, 2008, 3:40 AM
Thread Re: [Andy] ExpiryDate 		Alba 5345 Jan 29, 2008, 2:06 AM
Thread Re: [Alba] ExpiryDate 		Andy 5362 Jan 29, 2008, 2:11 AM
Thread Re: [Andy] ExpiryDate 		Alba 5339 Jan 29, 2008, 3:02 AM
Post Re: [Alba] ExpiryDate 		Andy 5385 Jan 29, 2008, 3:07 AM
Post Re: [Alba] ExpiryDate 		Andy 5419 Jan 29, 2008, 3:11 AM