Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: ExpiryDate

Jan 28, 2008, 3:34 AM

Andy

Veteran / Moderator (15041 posts)

Jan 28, 2008, 3:34 AM

Post #1 of 7

Shortcut

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.com

Merry Xmas and a Happy New Year!

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!
Custom Toolbar for IE and Firefox! - Compare our different Plugin packages *new*
Free CSS Templates

Jan 28, 2008, 3:40 AM

Andy

Veteran / Moderator (15041 posts)

Jan 28, 2008, 3:40 AM

Post #2 of 7

Shortcut

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.com

Merry Xmas and a Happy New Year!

Jan 29, 2008, 2:06 AM

Alba

Enthusiast (544 posts)

Jan 29, 2008, 2:06 AM

Post #3 of 7

Shortcut

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 (15041 posts)

Jan 29, 2008, 2:11 AM

Post #4 of 7

Shortcut

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.com

Merry Xmas and a Happy New Year!

Jan 29, 2008, 3:02 AM

Alba

Enthusiast (544 posts)

Jan 29, 2008, 3:02 AM

Post #5 of 7

Shortcut

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 (15041 posts)

Jan 29, 2008, 3:07 AM

Post #6 of 7

Shortcut

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.com

Merry Xmas and a Happy New Year!

Jan 29, 2008, 3:11 AM

Andy

Veteran / Moderator (15041 posts)

Jan 29, 2008, 3:11 AM

Post #7 of 7

Shortcut

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.com

Merry Xmas and a Happy New Year!