Just that simple! Thanks, that worked. Thanks, Mark
-----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 1:14 PM To: CF-Talk Subject: RE: CFDirectory Don't use the ## in the Where clause: <cfquery dbtype="query" name="getSource"> SELECT * FROM statsLevel3 WHERE dateLastModified <= <cfqueryparam value="#VARIABLES.dateRange#" cfsqltype="CF_SQL_TIMESTAMP" /> </cfquery> ........................ Ben Nadel www.bennadel.com -----Original Message----- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 1:09 PM To: CF-Talk Subject: CFDirectory Hi all, Trying to get a file listing from a directory, but only capturing the files that are older than 7 days previous to today (using the cfdirectory datelastmodified var). I'm able to retrieve the listing of all files, but I can't seem to get only the ones older than 7 days - throws an error. Can the filter var in cfdirectory be used, so I can eliminate the second query? Or should the second query be structured differently? <cfdirectory action="list" directory="c:\smarterstatsdomainlogs\somewebsite\W3SVC515241625\" name="statsLevel3" recurse="no" listInfo="yes"> <cfoutput query="statsLevel3"> #NAME# - #datelastmodified#<br /> </cfoutput> <cfset VARIABLES.dateRange = CreateODBCDateTime(Now() - 7)> <cfset VARIABLES.dateRange = DateFormat(VARIABLES.dateRange, 'mm/dd/yyyy')> <!--- <cfset VARIABLES.dateRange = DateFormat(VARIABLES.dateRange, 'mm/dd/yyyy')> <br /> <cfoutput>#VARIABLES.dateRange#</cfoutput> ---> <br /> <cfquery dbtype="query" name="getSource"> SELECT * FROM statsLevel3 WHERE #statsLevel3.datelastmodified# <= #VARIABLES.dateRange# </cfquery> Thanks, Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238157 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54