<cfset foodate = now() /> select * from footbl where col = <cfqueryparam cfsqltype = "cf_sql_date" value="f#oodate#" />
Or check for specific DB function for today's date. In Oracle we have sysdate.. where date = sysdate, I'm sure whatever DB you're using has a similiar function. On Mon, Jun 23, 2008 at 10:43 PM, John Barrett <[EMAIL PROTECTED]> wrote: > I am trying to update a page using cfquery. I have a db with some tips, and I > want to display todays only on another page. I tried using <cfset > today=#now#>. Basically I want to get the tip for today, and display it, and > have it done dynamically with CF. The only way I could get it not to throw an > error, was to use the where clause and use a date, but this I would have to > change manually. Another issue is that it is not displaying the tip, so I > think that there is an issue with the logic here:( > Can anybody help please, > Thanks > John > > <!---<cfset todaysdate = #Now()#>---> > <cfquery name="tip" datasource="MyDSN"> > SELECT ID, Topic, Text, Date > FROM tip > where > date = "06/23/2008" > </cfquery> > > <!---display current tip---> > Today's Tip:<cfoutput query="tip">#tip.Text#</cfoutput> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3777 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
