Is "dte_2dlcl" a column in the database? You can't execute a ColdFusion function on a database column in a query.
Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com On 1/13/2011 1:41 PM, Jay Birdsell wrote: > The dateDiff () is killing me! can someone please look at this and help me > clear my head. > > What I have is a db that tracks executive correspondence when drafts are due > and when the final response is due. I need a report that will list any > correspondence that has a draft or final date within 8 days of the run date > (today). I've read that i should be able to do this right in the select > statement. However I have found a clean concise example here is what I have > tried so far; > > try # 1:: > <cfquery name="final8" datasource="dev11g"> > select dateDiff('d',#today#,'dte_2dlcl') as m > from execcoresp000 > </cfquery> > > Results:: Error - "DateDiff invalid identifier" > > try# 2 > > <cfquery name="final8" datasource="dev11g"> > select dateDiff('d',#today#,'dte_2dlcl') as m > from execcoresp000 > where m< 8 > </cfquery> > Results: Error M invalid identifier > > try # 3 > <cfquery name="final8" datasource="dev11g"> > select dte_2dlcl > from execcoresp000.correspondence > where dateDiff('d',#today#,'dte_2dlcl')< 8 > </cfquery> > Results: Error - "DateDiff invalid identifier" > > > The other error i tend to get is "Missing right parenthese" > > i really dont want to get in a bunch of nested loops to do this. any ideas? > > tia, > > jbird > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340771 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm