Gossamer Forum
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
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 4772 Jan 28, 2008, 3:34 AM
Post Re: [Andy] ExpiryDate
Andy 4636 Jan 28, 2008, 3:40 AM
Thread Re: [Andy] ExpiryDate
Alba 4638 Jan 29, 2008, 2:06 AM
Thread Re: [Alba] ExpiryDate
Andy 4650 Jan 29, 2008, 2:11 AM
Thread Re: [Andy] ExpiryDate
Alba 4628 Jan 29, 2008, 3:02 AM
Post Re: [Alba] ExpiryDate
Andy 4678 Jan 29, 2008, 3:07 AM
Post Re: [Alba] ExpiryDate
Andy 4715 Jan 29, 2008, 3:11 AM