Gossamer Forum
(Advanced Search)
for
Jan 28, 2008, 3:34 AM
Andy
Veteran / Moderator (17298 posts)
Andy's avatar
Jan 28, 2008, 3:34 AM
Post #1 of 7
Views: 428
Shortcut
Quote Reply
ExpiryDate
Hi,

Got a weird one here - probably just having a brain freeze moment =)

Code:
SELECT * FROM glinks_Links WHERE ExpiryDate > 2147483647

..give 0 results

Code:
SELECT ExpiryDate FROM glinks_Links WHERE ID = 58803

The Link 58803 has an ExpiryDate of 2008/10/15 00:00:00 - which converts to 1224054000 -- which is LESS than 2147483647.

I always thought if a link wasn't set as a paid listing, the ExpiryDate was set to 2147483647 - so doing:

Code:
SELECT * FROM glinks_Links WHERE ExpiryDate > 2147483647

...should give you the listings that have been paid.

As I said - probably a stupidity moment, but if anyone can help, would be much appreciated =)

TIA

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Jan 28, 2008, 3:40 AM
Andy
Veteran / Moderator (17298 posts)
Andy's avatar
Jan 28, 2008, 3:40 AM
Post #2 of 7
Views: 424
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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Jan 29, 2008, 2:06 AM
Alba
Enthusiast (559 posts)
Jan 29, 2008, 2:06 AM
Post #3 of 7
Views: 408
Shortcut
Quote Reply
Re: [Andy] ExpiryDate In reply to
Quote:
SELECT * FROM glinks_Links WHERE ExpiryDate > 2147483647

Shouldn't it be
SELECT * FROM glinks_Links WHERE ExpiryDate < 2147483647 ?
Jan 29, 2008, 2:11 AM
Andy
Veteran / Moderator (17298 posts)
Andy's avatar
Jan 29, 2008, 2:11 AM
Post #4 of 7
Views: 408
Shortcut
Quote Reply
Re: [Alba] ExpiryDate In reply to
Hi,

Thanks for the reply.

I've tried both :/

This is the default:

2147483647 (i.e "non-paid")

This if for 2008/10/15 00:00:00

1224054000

..but the 2008 date is LESS than 2147483647 .. which is the bit thats got me confused :/

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Jan 29, 2008, 3:02 AM
Alba
Enthusiast (559 posts)
Jan 29, 2008, 3:02 AM
Post #5 of 7
Views: 405
Shortcut
Quote Reply
Re: [Andy] ExpiryDate In reply to
Perhaps I'm misunderstanding here but 2008 should be less than 2147483647 because
2147483647 is January 19, 2038
Jan 29, 2008, 3:07 AM
Andy
Veteran / Moderator (17298 posts)
Andy's avatar
Jan 29, 2008, 3:07 AM
Post #6 of 7
Views: 402
Shortcut
Quote Reply
Re: [Alba] ExpiryDate In reply to
haha - I think you have a point =)

I just assumed that it was Jan 1970 Pirate

Thanks for point that out! (having a bit of a brain dead week so far :/)

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Jan 29, 2008, 3:11 AM
Andy
Veteran / Moderator (17298 posts)
Andy's avatar
Jan 29, 2008, 3:11 AM
Post #7 of 7
Views: 401
Shortcut
Quote Reply
Re: [Alba] ExpiryDate In reply to
Hi,

Ah ha - worked out why I was getting more results that I was expecting =) Some entries had ExpiryDate's of -1

Quote:
ExpiryDate
-1
-1
-1
-1
1203689463
1203690341
1224054000
2147483647
2147483647
2147483647

That'd be why it was matching more than the results I was expecting <G>

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates