Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Tricky Date Range -> Article of Month

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 2465 Feb 13, 2001, 8:28 PM
Thread Re: Tricky Date Range -> Article of Month
qango 2428 Feb 14, 2001, 5:02 AM
Thread Re: Tricky Date Range -> Article of Month
Stealth 2425 Feb 14, 2001, 8:52 AM
Post Re: Tricky Date Range -> Article of Month
Stealth 2398 Feb 14, 2001, 8:14 PM