is tipdate a date? if you want to use CF there's always <cfqueryparam cf_sql_type="cf_sql_date" value="#now()#" />
On Wed, Aug 6, 2008 at 11:33 PM, John Barrett <[EMAIL PROTECTED]> wrote: > I am trying to modify a cfquery to not display data after the current date. I > tried to use the CURDATE() in MySQL, but that did not seem to work. I am > wondering if there is a way to set this is CF and use that in the Where > function? As you can see below I was able to do something, but I don't want > to change this daily! > The whole app will display tips for this month,and I am trying to figure out > what is the best way to go about this. > > Thanks in advance, > John > > My query looks like: > <cfquery name="rs_dailytip" datasource="#REQUEST.dataSource#"> > SELECT * > FROM daily_tip_new > <!---where tipdate <= CURDATE()---> > where tipdate >= "2008-08-01" and tipdate <= "2008-08-07" > ORDER BY tipdate DESC > </cfquery> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3906 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
