Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Version 1.x :

Tricky Date Range -> Article of Month

Feb 13, 2001, 8:28 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Feb 13, 2001, 8:28 PM
Views: 3167
Shortcut
Quote Reply
Tricky Date Range -> Article of Month
I am attempting to do something similar that other Links SQL users have attempted with date ranges, but...I have modded Links SQL v.1.13 to store a table of articles that includes the following fields:

isFeatured (enum, N/Y) - N = No, Y = Yes
FeatureDate (Date)

Now, I am attempting to dynamically show featured articles for the month...I've seen a few Threads about "Sites of the Month", but the code hacks are configured differently.

The following query works fine:

Code:

SELECT *
FROM tbl_AG_Articles
WHERE isFeatured = 'Y' AND FeatureDate = '2001-02-01'


I am attempting to use a monthly range to replace the hard coded DATE.

Any suggestions would be greatly appreciated.

Thanks in advance.

Regards,

Eliot Lee
Subject Author Views Date
Thread Tricky Date Range -> Article of Month Stealth 3167 Feb 13, 2001, 8:28 PM
Thread Re: Tricky Date Range -> Article of Month 		qango 3092 Feb 14, 2001, 5:02 AM
Thread Re: Tricky Date Range -> Article of Month 		Stealth 3091 Feb 14, 2001, 8:52 AM
Post Re: Tricky Date Range -> Article of Month 		Stealth 3052 Feb 14, 2001, 8:14 PM