Hi greg, Thanks so much for your help, but I think that MySQL didn't like this.
<cfset todaysdate = #Now()#> <cfquery name="tip" datasource="MyDSN"> SELECT * where Date = <cfqueryparam cfsqltype = "cf_sql_date" value="#todaysdate#" /> FROM tip </cfquery> <!---display current tip---> Today is:<cfoutput> #todaysdate#</cfoutput><br /> Today's Tip:<cfoutput query="tip">#tip.Text#</cfoutput> I get an error: You have an error in your SQL near 'where Date = '2008-06-23' FROM tip' at line 2 (this is stripped to save space, but it shows the important stuff) So I am getting closer, as now I can use today's date. I tried to use col as you had, but then I assumed that I would use Date which is the column name. Thanks, John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3778 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
