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:
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
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