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:4142 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
