Hi, John... I've been following your thread and have a couple of questions.
Do specific tips have to be displayed on specific dates or are you just rotating through all your tips and then repeating them? And from your previous posts, I gather that you are just collecting tips for use on the homepage of your website and will continue to collect more and just cycle through them, changing the tip each day? Rick John Barrett wrote: > Hi Paul, > Thanks so much `-` > I think that I finally have it: > <cfquery name="rs_dailytip" datasource="#REQUEST.dataSource#"> > select * > from daily_tip > where tipdate <= #today# AND tipdate >='2008-11-01' > order by tipdate desc > limit 21 > </cfquery> > > The thing is that I have the dates in the database from 2008-11-01 > till 2008-11-21, but I don't want to display tips passed today. > I found that SQL has "AND" and so I used the range in the where > clause, and then at the end I use the "limit" to give the size, or > the amount of rows. > > This is the only way I could get it to work, not sure if it is the > best way(that is the range) but otherwise I could not get it to work. > > Thanks so much for your help, > John > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4143 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
