thanks:) all is working now
----- Original Message ---- From: Paul Kukiel <[EMAIL PROTECTED]> To: CF-Newbie <[email protected]> Sent: Monday, June 23, 2008 9:17:07 PM Subject: RE: cfquery for today Hi John, Give this a try: #CreateODBCDate(now())# <cfset todaysdate = #CreateODBCDate(now())#> <cfquery name="tip" datasource="MyDSN"> SELECT * where Date = <cfqueryparam cfsqltype = "cf_sql_date" value="#todaysdate#" /> FROM tip </cfquery> Paul. -----Original Message----- From: John Barrett [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 June 2008 2:23 PM To: CF-Newbie Subject: Re: cfquery for today 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:3782 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
