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